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

Customer Support Database Support
1

catchy title eh :frowning:

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?

<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.. :frowning:

2

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;”

3

it’s for the mssql2005 you set me up with… :slight_smile:

but cool i needed to know that too.

4

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.

5

okie then that should get me going… thanks!

ctl