Microsoft.Jet.OLEDB question....

[cady]

I am having problems with a webpage that connects to an Access97 database using an ADODB connection. I think that I am having compatability problems, I have access97, but am running Windows 2000 professional. When I go to control panel and look at the list of drivers I have, neither Microsofl.Jet.OLEDB.3.51 or 4.0 are listed. I downloaded MDAC 2.6 but all I could find for 4.0 is Jet 4.0 Service Pack. Could someone please tell me what versions I should be using, where to go to download them, and once I download the Jet.OLEDB, how I get that in my list of drivers. Please be pretty specific, because right now I am feeling quite stupid!!!!

Thanks for any help!!!
Cady

[JoshT]

4.0 will work with both Access 97 and 2000 databases.

[Radames]

The 4.0 driver comes automatically with these latter versions of windoze...Perhaps what you mean is, when you are configuring the system dsn? The driver name is Access.

[cady]

Ok, thanks Radames, maybe you can help me, I apparently don't know how to connect to the database. I have a database call Inventory with a table call Categories with 3 fields called Category, subcategory, and subsubcategory ( I wasn't the one that named this database!!!) and I need to be able to populate 3 drop down boxes with these fields the second and third are populated depending on what the user chooses from the first and second boxes. When I go to the control panel/Data Sources (ODBC)/System DSN, I have Inventory for the Name and Microsoft Access Driver (*.mdb) for the Driver. Could you (or anyone else) help me with the code part to connect and populate the drop down boxes. I have done something like this before but it was a very long time ago and I can't remember how I did it!! Help please!
Cady

[monte96]

You don't use ODBC datasources with OLEDB.

You need to connect using the Provider connection string:


cnConn.ConnectionString = "Provider=Microsofl.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("MyDatabase.mdb") & ";"