please help me, i'm an idiot... :/

jetx86

jetx86

Perch
catchy title eh :(

i know the remote server's ip and stuff, and i can replicate the tables to that server, but what exactly do i change in this code for it to actually use the remote server?

Code: 
<connectionStrings>

<add name="ClubSiteDB" connectionString="Data Source=.\SQLExpress;Integrated Security=true;AttachDBFileName=|DataDirectory|Club.mdf;User Instance=True" providerName="System.Data.SqlClient"/>

</connectionStrings>

i know i need to change the Integrated Security=true, that's not a problem.. i just don't know how to tell it to use the remote.

tia, thanks, gracias, et al...

edit
now i wonder if this should go in the ms dev area of the forum.. :(
 
That is SQL 2005 code, you need to use SQL 2000 code it would look more like this:
"Data Source=serverIPorname,1433;Network Library=DBMSSOCN;User ID=Username;Password=thePassword;"
 
Try it for 2005 as well, it will work it uses the built in libraries, the path you gave is not only SQL 2005, but the Express version installed on a local server the method for getting to a remote server is the same.
 
You must log in or register to reply here.
Back
Top