I'm following through the Wrox book "Beginning ASP Databases" and I have created a two System DSNs, one for Access and another for SQL Server. In the ODBC Administrator I have stepped through each page successfully, and on the SQL Server DSN I get a successful connection test. But, using either one I get the same error, which is:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
The Access database is in the wwwroot folder (Win 2000 Pro & IIs 5). I tried my own code first, which failed, then copied the sample code from the book I'm reading (Wrox: Beginning ASP Databases) directly and it does the same thing. Ok, so what am I missing?
Here's the offending code (straight out of the Wrox sample code):
set oRS=server.createobject("ADODB.recordset")
oRS.open "Select * from People", "DSN=sailors"
oRS.movefirst
response.write "" & oRS("PeopleNameLast") & ""
Thanks!
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement