Connecting to Oracle via BDE

[Dave Fobare]

I'm having problems connecting to Oracle via the BDE!

Here are the particulars:

Personl Oracle, version 8
Delphi 5, Enterprise
Windows '98
This is *not* client/server, just trying to get a simple
app up and running that connects to Oracle8 via the BDE.

I have used the bdeadmin.exe to specify the following:

DLL32 = SQLORA8.DLL
VENDOR INIT = OCI.DLL
NET PROTOCOL = TNS

I am at a loss when it comes to SERVER NAME. Based on various
sources, I have tried "beq-local", which is one of the demo db's that
comes with Oracle, and I have also tried "2:". I have also properly set
the USER NAME and PASSWORD.

I have rec'd two types of errors: a "Vendor Initialization" error, an
"IDAPI service" error depending on how I set up the configuration.

Could someone either point out my surely-boneheaded error, or
at least provide me with a pointer to some instructions written in
readable English(like a tutorial, maybe)?

Thanks,

Dave Fobare

[Newsgroup]

Hi,

    For Vendor Initialization Failed : Open BDE Admin , Go to Configuration tab, Expand Drivers  > Native:

 

For Oracle in DLL32 Parameter Select DLL Name as SQLORA8.dll.

For Vendor INIT Parameter Select OCI.DLL.

 

(if you don't SQLORA8.DLL then Apply BDE Update 5.1.0 ).

 

Also, Create a Service in Oracle (using Oracle Net8Easy Config).

 

Give the Service name with <SERVICENAME>.WORLD as SERVERNAME in BDE.

 

================================================

Dave Fobare <edi...@the-sports-page.com> wrote in message news:3974f9a2@dnews...