We help IT Professionals succeed at work.

Unable to Access AccesDB from Delphi 2.0

lizzzard
lizzzard asked
on
Medium Priority
307 Views
Last Modified: 2010-04-04
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?
Comment
Watch Question

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

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

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.

Commented:
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.


Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.