Re: Connecting to O8 from Borland SQL Links

I've never used the Oracle Name Server, and I don't know if this is one of the options to having Oracle authenticated logons (ie. no password). If this is so, you still need to enter a password when logging onto Oracle through the BDE, anything will do as long as there is something in the password field.

James

On Fri, 24 Sep 1999 15:02:35 -0700, Ernie DeVries <Ernie.DeVries_at_nau.edu> wrote:

>The Oracle instances are 8.0.5. Paradox9 comes with BDE 5.01. I'm not
>sure about the "native drivers for oracle". I have installed the 8i
>client on my PC and I can connect through SQL Plus or through ODBC
>channels. I know that during the installation of WPO2K I chose to
>install "SQL Links", which as I understand it should include what I need
>to connect to an Oracle instance. Since I supposedly have what I need
>installed, I know the name of the instance, and the DBA's have set up
>the Oracle Name Server, I presume that this is just a configuration
>issue. The problem is that I can't seem to find the steps for doing the
>configuring of the BDE (or Alias within it) so that I can open an Oracle
>table.
>
>Nicolas Bronke wrote:
>>
>> > In my environment we are using the Oracle Names Service and my
>> > SQLNET.ORA file is configured to point to it for resolving instances.
>> > I'm trying to figure out how to connect Paradox9 to Oracle using the
>> > Borland SQL Links product that comes as part of Corel WordPerfect Office
>> > 2000 Professional. I can connect through ODBC data sources, but this
>> > adds a layer which slows down access & SQL Links is supposed to be the
>> > "direct" way to go.
>> >
>> > I'd appreciate some pointers from someone who has successfully done
>> > this.
>> Which Oracle-Release? Which BDE-Release? Does the native drivers for oracle
>> already exists on your BDE-Installation?
>> Knowing this points may help to help.
>>
>> Regards
>> Nicolas
Received on Tue Oct 12 1999 - 03:24:28 CDT