ASP Connection to WEB based SQL Server

• edpritch

  SSC Rookie

  Points: 44

  More actions

  October 24, 2002 at 4:27 pm

  #158519

  I am trying to get a good example of the way a connection is made to a SQL 2000 database on my ISP using ASP on my website. They are no help. I have the server IP address and the File.dsn from them. But not sure how use it in the connect string. The books and references I have are all assuming a local server.

  Thanks in advance for the help...

• Steve Jones - SSC Editor

  SSC Guru

  Points: 739116

  More actions

  October 25, 2002 at 10:48 am

  #439492

  MyConn = "driver=SQL Server;server=x.y.z.a;database=mydb;userid=me;pwd=test"

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones