Data source name not found and no default driver specified


Hi, I have IIS and SQL Server2K on the same machine where I am trying
to get an ASP file to return data. I can not get past this one error
though:

ERROR MESSAGE:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified
/WebFiles/Page1.asp, line 122


I've messed with and tripple checked each of the areas below
-Web Site's Configuration in IIS
-Registry key associated with ODBC Driver
-ODBC driver / DSN
-Changed the connection string in every way.


CONNECTION STRING:
MyConn= "PROVIDER=SQLOLEDB.1;DATA
SOURCE=xxx.xxx.xx.xx;UID=User;PWD=pwd;Network Library=dbmssocn;Initial
Catalog=DB Name;"

LINE 122:
<%Set MyConn = Server.CreateObject ("ADODB.Connection")
%>
<%Set RS=Server.CreateObject ("ADODB.RecordSet")%>


Any ideas?

Thanks,

.

Relevant Pages

  • Re: (0x80004005) ][ODBC Driver Manager] Data source name not found and no default driver specified
    ... did was do a Windows XP System Restore for Monday evening. ... system for the ODBC Drivers. ... >>properties, Security Tab, and changing rights. ... >>I'm sure someone else has had this problem with XP Professional and IIS ...
    (microsoft.public.inetserver.asp.db)
  • ado and connection string
    ... I'm testing it in a pc with Xp Pro and IIS 5.1, ... I've not setted a Data Source Name in "ODBC data administrator" ... "[Microsoft OLE DB Provider for ODBC Drivers]" ...
    (microsoft.public.data.ado)
  • ado and connection string
    ... I'm testing it in a pc with Xp Pro and IIS 5.1, ... I've not setted a Data Source Name in "ODBC data administrator" ... "[Microsoft OLE DB Provider for ODBC Drivers]" ...
    (microsoft.public.vb.database.ado)
  • Data source name not found and no default driver specified
    ... I have IIS and SQL Server2K on the same machine where I am trying ... to get an ASP file to return data. ... Microsoft OLE DB Provider for ODBC Drivers error '80004005' ...
    (microsoft.public.inetserver.asp.db)