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!
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only