Dear All,



I'm converting over to SQL Server 2000 from Access 97, but after having

installed SQL, none of my Access ODBC DSNs work.



The operating system I'm using is Windows Server 2000 Advanced.



I get the following error:



"Microsoft OLEDB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC

Driver Manager] Data source name not found and no default driver specified."



I assuming that it is possible to run applications that use Access and

applications that use SQL Server on the same server.



The way that I'm trying to access the data in the script is:



set ors = Server.CreateObject("ADODB.Recordset")

ors.open "tableName","dsnName",adOpenKeyset,adLockOptimistic,adCmdTable



Thank you in advance for any ideas.



Regards

Marcus

2 different connections for access versus sql server..they both can coexist

on the same server

ACCESS....

Dim  objConn

   set objConn = Server.CreateObject("ADODB.Connection")

     

   objConn.open "Provider=Microsoft.Jet.OLEDB.4.0;" & _

            "Data Source=c:\InetPub\wwwroot\youraccessdirectory\db.mdb;" & _

            "User Id=admin;" & _

            "Password=;" 

SQL SERVER....

Dim objConn

   Set objConn = Server.CreateObject("ADODB.Connection")

   

   objConn.Open "DRIVER=SQL Server;SERVER=ServerName;UID=sa;APP=Microsoft

Open Database Connectivity;WSID=SNRM_48001F5M;DATABASE=databasename;User

Id=sa;PASSWORD=;"

 

this one uses an ODBC



Someone else out there may have a different way.

All recordset statements as you have shown should not be a problem.  Its the

connection

Ron

  



-----Original Message-----

From: Marcus Hamilton [mailto:marcus@p...]

Sent: Wednesday, September 12, 2001 12:53 PM

To: ASP Databases

Subject: [asp_databases] SQL Server breaking Access DSNs





Dear All,



I'm converting over to SQL Server 2000 from Access 97, but after having

installed SQL, none of my Access ODBC DSNs work.



The operating system I'm using is Windows Server 2000 Advanced.



I get the following error:



"Microsoft OLEDB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC

Driver Manager] Data source name not found and no default driver specified."



I assuming that it is possible to run applications that use Access and

applications that use SQL Server on the same server.



The way that I'm trying to access the data in the script is:



set ors = Server.CreateObject("ADODB.Recordset")

ors.open "tableName","dsnName",adOpenKeyset,adLockOptimistic,adCmdTable



Thank you in advance for any ideas.



Regards

Marcus







 




$subst('Email.Unsub')