This is the following error that i get.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
error in asp file line 82:
Here is what i do to establish connection. I use a system DSN, DSN was also supposedly created on the server-side as well.
Set xConn = Server.CreateObject("ADODB.Connection")
xConn.ConnectionString = "DSN=CMP2 Test"
What is the problem? I want to be able to establish a connection with this database on SQL Server.