asked on

Unable to use Access database aliases

I installed the C++ Builder Professional edition on my machine alongside my Delphi 3.01 Client/Server. This was not a good idea, as it screwed up my Interbase configuration.

I have therefore re-installed Delphi 3 C/S, and my Interbase setup is now OK. Unfortunately, I am now no longer able to use my Access database alias.
I define the alias using the driver type MSACCESS, but when I try to open the database connection, I get the following error message:

"Cannot load an IDAPI Service library"

I am using Windows NT 4.0 (option pack 3), and I have Access 97, DAO 3.0 and DAO 3.5 installed.

What do I do to get around this problem?

Thanks in advance for any input,

AndersWP

JimBob091197

Hi

You may need to reinstall the latest version of the BDE, available from Borland's (Inprise) web site, or I can e-mail it to you. This should get Access 97 aliases working again.

If you'd like to me to mail it to you, e-mail me at davekw@iafrica.com.

Cheers,
JB

AndersWP

ASKER

Thanks, that did the trick. It turned out the by default BDE used DAO 3.0, which for some reason did not work. The updated BDE allowed my to change that to DAO 3.5, which does work.

I believe I should credit you for solving this, but I can not do that as your contribution was a comment rather than a solution. If you change it to a solution, I will mark is as accepted.

Yours,
AndersWP

ASKER CERTIFIED SOLUTION

JimBob091197

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial