Unable to Access AccesDB from Delphi 2.0

I'm trying to open an ACCESS97 DB from Delphi. I've made a source in ODBCAD32,configured it in DBE and made an alias. The ODBC dll's (which were given by Delphi) were not the good ones,so I replaced them with those I could find in ODBCAD32 (SIMBA.DLL and ODBCJT32.dll).When I try to access the Database from Delphi it gives me the following message:'Driver not known to system'. So I think I've choosen the wrong DLL's. Can anybody help?
lizzzardAsked:
Who is Participating?
 
M_HoeperConnect With a Mentor Commented:
Half year ago I had nearly the same problem. I solved it by buying the ODBC Drivers Kit from Microsoft. The ODBC-Driver Microsoft spreads with its Access-Database only works well with Office Products and not with self-made programs. After I installed the new ODBC Drivers I hadn't any problem any more.

Possibly you can get the Kit at the Microsoft Web-Page.


Hope it helps

Marc
0
 
lizzzardAuthor Commented:
It worked OK with Access 7.0,I have to buy Delphi 3 to make it work with Access97 as well though. Thanks for your trouble.
0
 
M_HoeperCommented:
It have to work well with Access97, too. If You have problems with Access97 send me a note. We can compare the ODBC Engine and the drivers. Hmmm... I use the BDE 3.5. You can download the free update from www.borland.com.


0
All Courses

From novice to tech pro — start learning today.