PDA

View Full Version : Problem connecting to SQLServer database



steveg
Jan 27th, 2006, 11:04 AM
Hi,

I have just finished writing a asp.net application that connects to an sql database, up until now the database has been running on my local machine, however, now I have to test it with the database running on a seperate server and I have no idea how to go about it.

Im reconing that its got something to do with this line in the code

dim myconn as New SqlConnection("initial catalog=stes2;User Id=sa;Password=")

the database (as you can see) is called "stes2" but now its on a machine called "IVR" anyone know how I specify the path ?

Thanks in advance

Steve.

Brandoe85
Jan 27th, 2006, 01:14 PM
Yep, take a look here:
http://www.connectionstrings.com/

If you still can't get it after looking at those connection strings, give us a shout back.

Good luck;

steveg
Jan 27th, 2006, 01:20 PM
Nice one mate.

Job sorted !

Thanks