Creating a OBDC Connection in SQL Server 2000
Posted on 2005-04-27
I am trying to resurrect an ASP application. I have installed the application files on a Windows 2003 Server running SQL Server 2000 Enterprise (mixed mode authentication). I am having problems making a DB connection from the ASP pages.
Here is the script that is trying to make the connection in the DB:
Set oDB31 = Server.CreateObject("ADODB.Connection")
Set objRS31 = Server.CreateObject("ADODB.Recordset")
The script says I need to specify a UID and Password. When setup a ODBC connection for the USER DSN (focus) in the OBDC Data Source Administrator, I think I need to specify the authentication of the login ID as the “With SQL Server authentication using login ID and password entered by the user” which I do. There is also a check in the box for “Connect to SQL Server to obtain default settings for the additional configuration options” Which I put in the “focus” ID and password. The test connection then fails????? Default database point to the focus123 DB.
I have setup a user account for “focus” in the SQL Server focus123 DB and gave it full permissions.
The ASP page error is:
Microsoft OLE DB Provider for ODBC Drivers error ‘80004005’
[Microsoft][ODBC Driver Manger] Data source name not found and no default driver specified…….
Any help would be much appreciated!!