Database Path change

Question

Hi I have developed one windows application and now i want to run that application in other system,but here my doubt is ... how to give path(connectio string) for DB to run the application in other system...?

Amit Gupta · Answer

Hey If you are running Sql Server then use . (Dot), it determine the current user Put in the DataSource/Server = . If you are running Sql Server Express then put in the DataSource/Server =.\InstanceName Where InstanceName is SqlExpress Check reference https://www.connectionstrings.com/sql-server/

Amit Gupta · Answer

Connection string is correct, There are several other reasons while attaching the mdf file. Please ensure the following points: 1. The Data Directory is not compressed 2. Run the application as an administrator 3. mdf file is valid. Do let me know, if this works !

Thiruppathi R · Answer

You can use app.config & write below code like "xxxs_ADO" providerName= "System.Data.SqlClient" connectionString= "Data Source=xxx;Initial Catalog=DBName;User ID=sa;Password=xxxxxx" /> OR Use attribute "DBName" value= "XXXX" /> "Initial Catalog" value= "XXXX" /> "Server Name" value= "XXXX" /> "Password" value= "XXXX" />

Rafnas T P · Answer

read this link below, you wil get some idea http://stackoverflow.com/questions/12266924/how-do-i-read-the-current-path-of-datadirectory-from-config-settings

siddu benagal · Answer

no i am not using remote server ,i am using local db and if i give full path means it wil work bt when it comes to Datadirectory its throwing error

Amit Gupta · Answer

How suddenly the exception changed? 1. From where you are accessing the mdf file, is it from a LAN? 2. Try adding User Instance =True; to the connection string. 3. If the DataDirectory in your connection string is not working then try to give the full path of the file and try again. 4. If above points are not working then open ssms check your database, make sure it was not in recovery pending mode Hope this will help you to get your issue resolved

siddu benagal · Answer

An attempt to attach an auto-named database for file failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. same problem is coming again and again....

Amit Gupta · Answer

Try restarting SQL Server instance or follow the link http://www.dotnetfunda.com/forums/show/9225/sql-server-a-connection-was-successfully-established-with-the-server-b

siddu benagal · Answer

Now i am getting this error A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

Amit Gupta · Answer

Change to this "ConString" connectionString= "Data Source=.;Integrated Security=True;AttachDbFilename=|DataDirectory|database1.mdf;" providerName= "System.Data.sqlClient" />

siddu benagal · Answer

this is the my connection string providerName="System.Data.sqlClient"/> and i am using sql server 2008 r2

Amit Gupta · Answer

Can you share your connection string and screenshot of error (if possible)

siddu benagal · Answer

Hi amit i have tried according to you bt i am getting below this error The user instance login flag is not supported on this version of SQL Server. The connection will be closed.

Satyendra Patel · Answer

hii, It is not so complex ,it is simple.firstly you set the connection string in your application.For Example your database path is( C/Database /localDB) in your system.when you want to run your application on another system then your data base are save as it(C/Database /localDB)like as your local system.

Amit Gupta · Answer

Donot hard code the connection string, use the config file to store and access from it.