Deployement of app with db

Julian Tabaku

Hi all.... i have created an app with visual basic and sql server ... i published it .... but when i run on any other computer i cant connect to my db ???????? -by the way the connection that i have used is

Dim cn As New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Gerti\Documents\Visual Studio 2010\Projects\BAR_RES\BAR_RES\CoffeeDatabase.mdf;Integrated Security=True;User Instance=True")

PLEASE HELP i know i should change the conn string but how??

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Prakash Tripathi10y ago
Accepted answer
Do you have the same path in new machine i.e. C:\Users\Gerti\Documents\Visual Studio 2010\Projects\BAR_RES\BAR_RES\CoffeeDatabase.mdf
If not, update the new machine path and try again.

If this helps to address the issue, please close the thread by accepting the answer.
0
Julian Tabaku10y ago
Yes guys you were right... i needed to change my connection string and i found a way around that ... i got my coonection string from app.config if anyone has the same problem as me tell i can share my answer ..... remember peace brother ans sisters
0
Julian Tabaku10y ago
hi guys thanks for writting back.... when i publish the program from visual studio the vs creates a copy of my database .... when i install my program in a new machine the db is there i cant to the db that is there
0
Bhuvanesh Mohankumar10y ago
Hi Julian,
Where ever you deployyour application it will check for the physical location of database file
say your file location "C:\Users\Gerti\Documents\Visual Studio 2010\Projects\BAR_RES\BAR_RES\CoffeeDatabase.mdf"
Either, you have to have acopy of the ".mdf" file in the deployed machine with full Read/Write Access to the folder to solve the issue.
I suggest you to have the ".mdf"in "AppData" folder of your solution folder.
Mark as answer, if helpful.
0