Connecting To SQL Database Over Network

[OrWolf]

I have created an ASP web page that is currently connected to a test Access database. It's now time to move the connection to the live SQL database, however I'm having a hard time coming up with the correct syntax. The web server and SQL server are two seperate boxes (server17 and server58 respectively). What's the best way to set up this connection?

 

[link9]

Easiest way is to set up a DSN for the DB Server on the Web Server, and then just use that:

dim con
set con = server.createobject("ADODB.Connection&quot
con.open ("DSN=dsnName;UID=userID;PWD=password&quot

Should fix you right up --


Paul Prewett