Re: (Delphi 3 and Oracle 7/8) Which way to connect Delphi to Oracle?

From: Christoph Jüngling <Juengling_at_gmx.de>
Date: 1998/03/01
Message-ID: <6dblmq$3rq$1@news.nacamar.de>#1/1

On Mon, 23 Feb 1998 08:40:35 +0200, "Billy Verreynne" <vslabs_at_onwe.co.za> wrote:

>Launch BDE Admin and configure the native BDE Oracle driver to use the
>correct Oracle DLL (the VENDOR INIT setting the CONFIGURATION tab under
>\drivers\native\oracle). The dropdown box gives you a list of 7.x DLLs
that
>are supported. If you're unsure which DLL to exist on your PC, look in
the
>\ORAWIN95\BIN directory.

Done, thank you.

>In Delphi, create a TDatabase object, set the DRIVER to ORACLE and use
the
>SERVER NAME (tns alias), USER NAME (Oracle userid) and PASSWORD (Oracle
>password) settings as parameters for the connection.

SERVER NAME seems to be DATABASE NAME, isn't it? If so, I can't leave this field blank (I'm currently using Personal Oracle 7.2, Trial Version), and "2:" (as recommended in the Oracle Help File) is rejected as a "Bad Parameter". "ORCL" also is unknown, I guess because there is no TNSNAMES.ORA file in my \orawin95\network\admin directory.

Have you got any further tips in this case?

TIA
Chris Received on Sun Mar 01 1998 - 00:00:00 CST