BDE and Personal Oracle 7 drivers

Does anyone know which Vendor and DLL32 drivers to use when linking the BDE to an Oracle 7 DB.  I keep getting Vendor init failures.
MTXOCI.DLL gives a General SQL Error when trying to open the DB using BDE Admin or BDEexplorer, and ORA73.DLL just gives a vendor Init failure.

HELP?
PLEASE?
ma8yrAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

intheCommented:
Hi
ORA73.DLL should work but
SQLORA8.DLL is the driver that works with Oracle 7 & 8 and Personal Oracle.
this dll should come with latest bde if you dont have it you can download latest bde from borlands web site.
did you specify the full path to the dll?


Regards Barry
0
intheCommented:
you can get the bde 5.10 with the latest drivers from here:

http://www.borland.com/devsupport/bde/bdeupdate.html
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ma8yrAuthor Commented:
I have Delphi 4 (prior to updates)
I would have thought the dll's would be here.

No I dont specify the whole path.

and...
SQLORA8.DLL doesn't seem to want to work at all!
the error msg = "couldn't load IDAPI service library, File:SQLORA8.DLL etc..."


0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

yk030299Commented:
listen
0
intheCommented:
try again setting your vendor init to ora73.dll and dll32 to sqlora7.dll
and then make sure that the <orahome>\bin is in your path so the Oracle dll's can be found by Windows when the BDE tries to load them as this could be the problem itself not the dlls
 
0
ma8yrAuthor Commented:
You are my hero.

I noticed a few days ago that the path was bad, some program hadd added something with a two word directory name and wasn't using quotes, so the path statement failed at machine startup.
I completely forgot about this.
In the end i used SQLOra32.dll and ora73.dll

the DLL32 SQLORA7.DLL doesn't exist.

Thank you so much, you can't begin to understand the relief this end.

0
intheCommented:
:-) glad to help
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Delphi

From novice to tech pro — start learning today.