rwallacej
asked on
ConnectionString for another PC
Hi
I've got application that works fine on development PC. Its server name is \PC144\SQLExpress. The ConnectionString is programmed in it seems to the application config / XSD file by visual studio automatically.
The server name on target pc could be anything e.g. PC192\SQLExpress.
What does one do to cater for this? I thought if the Database NAME in both systems were same it would be OK ???
Thanks
I've got application that works fine on development PC. Its server name is \PC144\SQLExpress. The ConnectionString is programmed in it seems to the application config / XSD file by visual studio automatically.
The server name on target pc could be anything e.g. PC192\SQLExpress.
What does one do to cater for this? I thought if the Database NAME in both systems were same it would be OK ???
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
patrikt - there doesn't seem to be a config file in the build, only .exe, .pdb etc
gbshahag - I'll try this
gbshahag - I'll try this
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
gbshahag :
\SQLExpress
works, thank-you
patrikt :
I have awarded points for your contribution too
thanks
\SQLExpress
works, thank-you
patrikt :
I have awarded points for your contribution too
thanks
If your connection string is in configuration file just change server name and if needed database name and it is ready.
Patrik