I am trying to create a connection to a SQL Server 2005 DB within an ASP page using the following code:
Set Conn= Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=SQLOLEDB; Data Source = "" Initial Catalog = ""; User Id = ""; Password=''"
The error message I am receiving says that the set conn method is outdated. Is there a better way to create a connection?
Set Conn= Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=SQLOLEDB; Data Source = "" Initial Catalog = ""; User Id = ""; Password=''"
The error message I am receiving says that the set conn method is outdated. Is there a better way to create a connection?