Thanks Brian. I fixed it earlier today by doing an IIs Restart. I don't know what was causing the problem, but now it works.
I have a new problem though.
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, 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 the heck 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") & ""
I should probably post this in its own thread, but wondered if you happen to know a solution?
Thanks.
Précédent
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