Beginning databases

[Wynd]

Can anyone recommend to me any good beginner's tutorials on using Access 2000 databases in ASP?

[Psyrus]

Active Server Pages 3.0 from Sams is pretty good.


Chris

[Wynd]

Ok, I found a tutorial online, and I am doing what it says, except when I try to run the ASP page, i get this error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005' 

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 

/Contacts.asp, line 12

Seems like I need drivers of some sort, can someone help me with this? The ASP page is attached if you need it.

[monte96]

1) Make sure you have MDAC installed so you have the ADO objects and OLEDB drivers installed.

2) Don't put ADO objects in the session object.

3) You are using a DSN called "ASPDeveloper". Make sure you have it set up in the ODBC admin tool.

4) You should really avoid using ODBC to hit any database that has an OLEDB driver. The OLEDB driver will always be faster.