Re: Connecting Delphi / WfW3.11 to Oracle / HP-UX sql server?

Raymond Allo (rallo_at_world.net) wrote:
: Actually you can buy SQLLinks seperately, you don't have to buy the
: Client/Server Edition. Saves a bundle.
 

: Raymond

: staccuc_at_riq.qc.ca (Sylvain Taccucci) wrote:
 

: >stico!hoover_at_dim.chemie.uni-bielefeld.de (Uwe Schuerkamp) wrote:

: >>Dear netters,
 

: >>we're trying to connect to an Oracle Sql server running on an HP UX
: >>host using Delphi 1.0 under Windows 3.11. We have tried to find out
: >>about how to do this with the Borland support line, but people there
: >>have been extremely unhelpful telling us to obtain a valid contract
: >>first before they would answer such questions.
 

: >>All we would like to know if it is possible with an out-of-the-box
: >>delphi installation (or out-of-the-CD, rather :-) to access the SQL
: >>server running on the HP-UX machine. It has an entry in /etc/services
: >>on port 1525 which points to the name "orasrv".
 

: >Without the Client/Server version of Delphi you can do this only by
: >using an ODBC driver for Oralce and using the Delphi BDE configuration
: >utility to use the ODBC driver. In this configuration you hace 2
: >layer of software, BDE talks to ODBC who then talks to Oracle, so it
: >can be a bit slow...
: >With the Client/Server version of Delphi, Borland supply BDE driver to
: >connect to Oracle so you just have to install the Oracle SQL*LINK
: >driver. I use it for reaching Oracle running under OpenVMS without
: >problem.
 

: >Goof luck.

I am currently using the Borland SQL-Links to connect to our Oracle sever on our 4 HP 9000 Unix Machines. First you need to know the address of your server, ours is like this T:sdc6:D1

The T: specifies TCPIP connection and the rest is the server name. First you need to install the SQL-Net drivers from Oracle themselves and make sure you can connect to the database with that. Then use the ora71win.dll and you should be all set. I am using the regular version of Delphi with the latest SQL-Links and BDE from the Borland C++ compiler v4.52 and everything works fine.

--
 _____________________________________________________________________________
| Andrew H. Grilk    -=-    Securities Data Company    -=-     agrilk_at_ios.com |
|There are two major products that came out of Berkeley: LSD and UNIX.  We    |
|don't believe this to be a coincidence. -- Jeremy S. Anderson                |