Programmatically Attach With Server Instance Through Program?
Feb 2, 2012I need to attach my database, that resided in the MyData directory of my application folder, to the instance of SQL server on client's machine. [code]...
View 2 Replies
ADVERTISEMENT
How To Programmatically Connect With Server Instance
Feb 2, 2012[code]....
View 5 RepliesAsp.net - Attach A Programmatically Generated PDF To An Email And Send It?
May 23, 2012i am trying to read a html file and convert it to pdf using itexsharp and send it as attachment by email : this is the client side code
[Code]...
Getting The Local Instance Of SQL Server Rather Than A Named Instance
Jul 29, 2010A while ago, I wrote a web-based guestbook application that wrote it's own database.
My code was very amateurish, but, as it was my very first publication, I was very happy with it. Only about a month after I'd published it did I realize I'd made a huge mistake in the code.
I've only ever connected to a specific named instance of SQL Server, and it occurred to me that, if the SQL Server instance has a different name than the one I specified, it wouldn't work.
So, since my users will probably not know what the name of the instance of SQL Server that's running is, I thought adding a field where the user can specify it would help if they do, but what if they don't? My answer was to get the local instance, regardless of name.
I tried Data Source=.local;, Data Source=.; and other variants, but nothing worked.
Error 5 When Attach Sql Database .mdf Files To Server
Jan 10, 2011I tried attach .mdf file to server via vb.net code for deployment my application .I put .mdf and log in debug folder and I used this connection string.[code]
View 2 RepliesAdd A Class Instance Dynamically / Programmatically?
Jan 15, 2011Am a geriatric coming back to programming after a decade's rest. Keeping it very simple. An empty form. As the form loads, create a Black button (OK) and also create a class which itself creates a single Cyan button. Am using VB 2010 Express. When I run, it creates the Black Button but not the Cyan (i.e. the one that is generated by the class).
[Code]....
Asp.net - Programmatically Determine Name Of CKEditor Instance?
Mar 30, 2010I've added a CKEditor instance programmatically to my page in the code-behind of my ASP.NET page:
[code]...
which works fine. I can get the HTML on the postback and do stuff with it.However, I also want to do some client-side stuff with it, specifically take a selected item out of another control, and insert it into the text by handling the onchange event.So, how can I get the name of the editor instance in the JavaScript, so that I can do stuff like:
[code]...
Create New Instance Of Sql Serverat Programmatically
Mar 7, 2009i need to programmatic ally create new instance of sql server in vb.net.i develop the database management project. i need new instance at windows authentication.
View 1 RepliesDeployed And Installed Application / Want To Attach Database Within SQL Server Management Studio
Mar 9, 2009I've developed an application in VB2008 express and have installed it to another PC. The installation has put the mdf file in c:documents and settingsuserappsdata.I want to attach this with SQL Server Management studio but when I try to browse to the file in order to attach it, I find I can't browse further then C:documents and settingsuser.
View 3 RepliesPublish Program & Attach A DB?
Mar 11, 2010I have created a program and i have managed to publish my application. I have set it up to be installed via CD but it does not attach the MSAccess DB. how do I add the DB?
View 2 RepliesAttach A Sql Database From Program Start?
May 5, 2009I'm not sure what is the best approach. Here is what I'm trying to do. I have installed sql express 2005 and sql express manger as pre-req before my program is installed. Now I would need to attach a DB to my new sql express instance. I'll be using windows login for this. I pretty much can not touch sql express, and run it as it was installed. No changing settings. Now I can run the SP_AttachDB from sql, but how would I automate that? I have tried the connection string, with the attach database option, but it's not working.
View 10 RepliesOptions To Attach An Uninstaller With The Program?
Oct 29, 2009when publishing a program , is there any options to attach an uninstaller with the program ?
View 5 RepliesVS 2010 Attach Form To Another Program?
May 30, 2011After reading a thread that said that other programs are out of my forms coding zone, is there a way i can attach my form to another program so that it will be in its coding zone and my form will be able to click on it?
View 1 RepliesAttach A File In Email Sending Program?
Dec 26, 2009I'm making a windows form.Here is my current code:I don't have any idea on how to link the open file dialog with the file that I am going to attach.
Try
With OpenFileDialog1
'OpenFileDialog1
[code].....
Attach A File To Your Program To Copy To Users PC?
Jul 15, 2010I know this probably sound like a virus but I mean like if I add an existing item or reference to my project and that is like a video file for an intro to a game so when people play the game it can show my video. How can I get that video to copy from my program to their PC?
View 14 RepliesAttach File To Email Note In Program?
May 8, 2010I am using the following code to create an email note[code]...
View 2 RepliesVS 2010 - Developing An Automated Command Line Program - Attach The Timer ?
Feb 15, 2012The code in question is in place, and it works. The project is all but wrapping up. That being said, I would love to find a better way to run this section of code in an x64 system so I have the solution ready for future projects. What I currently have in place is as follows:
Function TimeDelay(vDelay)
Dim vTimmer, vTargetTime
vTimmer = TimeValue(Now)
[CODE]...
Now I know the easy way to achieve my goal would be to use the timer object in Visual Studio. The problem I ran into is I was developing an automated command line program. As such there was nothing I could attach the timer to (that I'm aware of). I just needed to pause the program for a few seconds to allow the DTSX package (SSIS file if you're not familiar) to load the file before I remove it from the staging folder.
While I was doing research for this issue I came across the old Sleep() function (referenced to a library in kernel32 as I understand it...never used this before either). When I tried to use this on my current system (64-bit system) I received stack overflow errors. Additional research lead to something called wow64, but I did not have enough time to fully research what this is / how to use it.
Add Users To SQL Server Programmatically?
Dec 30, 2009So I'm creating this app that will install SQL server 2008 express, add some SQL users and then import a database.
Is there a way to create users for SQL express in Vb.net?
Finding The Uptime Of A Server Programmatically?
Jun 11, 2009Does anyone know of a way to programatically find the uptime of a server running Windows 2000? We have a service running on the machine written in VB.NET, that reports back to our server via a webservice.
View 4 RepliesC# - Setting Server Bindings Of IIS 6.0 Programmatically
Jul 23, 2010I'm trying to set up an installer to register a web site. Currently, I've got it creating an Application Pool and Web Site under Windows Server 2003. Unfortunately, whenever I try to modify the ServerBindings property to set the IP Address, it throws an exception at me. I first tried this because the documentation here told me to [URL]. I'm currently using VB.NET, but C# answers are okay too as I need to switch it over to using C# anyway.
[Code]...
Add The Database To SQL Server Instance?
Oct 18, 2010I am adding a datasource to a form.I have add the database to my SQL Server instance.
From the wizard i have succed to connect to the database
The test is OK
But at the last step to save the connexion this is the error message i am receiving an unexpected error has occured :
[Code]....
I thought because i did not yet build the solution. I did it but the same error message remains.
How To Install New Instance On SQL Server
Feb 20, 2012Is there nay way that my application could create a new instance (say MyInstance) and attach my DB to that, with sa password?
View 6 RepliesInstall New Instance On SQL Server?
Feb 20, 2012Is there nay way that my application could create a new instance (say MyInstance) and attach my DB to that, with sa password?
View 1 RepliesSQL Server's ServerName/Instance Name
Aug 26, 2011I am trying to Get the SQL Server 2005's Server Name or Instance Name in Combobox but unsuccessful.
Tried to access by Registry, tat produced error
OSQL -L did not list any servers
Find SQL Server Instance On Other Computer On LAN?
Aug 8, 2011I have the following function to find a SQL Server instance. It works fine on local computer. Would you please tell me how to use this function to check an instance on other computer on a Local Area Network? I am using VS 2008 (.NET Framework 3.5) and SQL Server Express 2005.
Private Function MyInstanceFound(ByVal MyInstanceName As String) As Boolean
Dim InstanceFound As Boolean = False
Dim MC As ManagedComputer = New ManagedComputer()
[code].....
Programmatically Modifying A File On Windows Server 2008
Nov 23, 2009I have written a VB.NET 2008 application, incorporating Microsoft.Office.Interop.Excel, that modifies an existing Excel 2007 spreadsheet. It works perfectly on my WinXP development computer.When I upload the app to a Microsoft Web Server 2008, it opens the file and reads from the file, but when the app tries to save the file, it throws this exception:"System.Runtime.InteropServices.COMException (0x800A03EC): 'july2009.xlsx' is read-only. To save a copy, click OK, then give the workbook a new name in the Save As dialog box."The file is NOT read-only, nor is it opened by any other user or app.The app and the Excel file both reside on the D: (data-only) drive.My first instinct was to look at file permissions. When nothing else worked, I literally created a temporary Group, added EVERY user and security entity to it and granted the group full control of the entire D: drive. No luck.
Then I tried manually elevating the permission by running my app as administrator. No luck.Finally, I copied the file to my XP development computer and ran the app there. Of course it worked perfectly.Can anyone please tell me how to give my program permission to edit a file on Server 2008?
VS 2010 Error 26 Locating Server / Instance Specified
Feb 12, 2011When I attempt to add a Service-based Database in VS2010, when starting a new project in VS2010, I receive the following error immediately after clicking "Add" when the Service-based Database is selected.A network-related or instance-specific error occured while establishing a connection to SQL Server. The server was not found or is not accesible. Verify that the instance name is correct and that SQL Server name is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified.)I've googled this problem and found this topic (url...), which wasn't able to help me. I'm still finding additional topics to troubleshoot with as well..
View 1 Replies.net - Server Halts Due To Large StringBuilder Instance In Memory?
Aug 2, 2010So, I have this code that grabs a bunch of data from the database, and performs a bunch of calculations on that data. However, this is not what is causing the halt. The halt is coming in when I take all that "final" data that has been prepared, and go to write that into a text file.
Each line in the text file is being created from data that has had calculations performed on it. Each line "corresponds" to a record from the database. A user will have to perform this file export usually on about 30-40 thousand records at a time. Now, even though I am using a StringBuilder, this still halts because of the pure mass amount of records.
What I do currently in the code is create one StringBuilder, append all the data (after calcs) to it, convert it to a String, add it to a List(Of String) to be returned from the Function, and then clear the StringBuilder, and do the same for the next row, and I do this until each row has been created and appended, converted, and then inserted into the List.
Then, another class receives this List(Of String) and takes each String and eventually appends it to a file.
Does anyone have an idea of how to improve this code and make it so it doesn't halt the server every time? The reason it wasn't found out until now is because when I tested it locally I was testing it on only 1-50 records at a time.
[Code]...
Find SQL Server Instance Install Path Using .NET In Windows 7?
Dec 12, 2011I have an application that allows the user to conduct database backups and restores. The users had been using Windows XP, with network security that allowed users to read the registry. For restores, the installation path to the SQL Server named instance was easily found by looking up the instance name in the registry using
restoreDir = My.Computer.Registry.GetValue("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\" & m_DatabaseInstanceName & "\Setup", "SQLPath", Nothing).ToString
They have recently upgraded to Windows 7, and locked down the registry so that users can not read values from it. Is there a way (via code) to find the path to a named instance of SQL Server, so that the app can automatically place the database files (mdb & ldb) in the correct folder?
Server Handle Multiple Clients Simultaneosly At An Instance?
Sep 22, 2011I am facing a problem in VB .net Client/Server application where I am successfully able to talk between them using TCPListener and TCPClient class usage. However, when I try to connect another Client to the same server on the same welcome port, it errors out throwing an exception or behaves very unexpectedly.Isn't it true that the Server connection is on a WELCOME PORT for all the clients, and that each client connected gets a new port to carry on its communication with the server AUTOMATICALLY (according to the Tomcat webserver working)
View 2 Replies