James,
First off, Linux does not use DLL's, that's a MicroSlop thing. It does make
use of .so files for Shared Object, which is a Unix thing.
Now as to the subject of ODBC: ODBC stands for Open Data Base Connectivity
which again was a MicroSlop idea that has caught one. OK, I'll give Gates & CO
a pat on the back for a good idea that went bad elswhere. Anyway, the idea is
that your application has a common interface, namely ODBC, that then connects to
each database vendor's proprietary transport. This way the interface to the
database from your perspective (as the developer) is the same no matter who's
database is underneath. In theory it is a great idea, but the implementation
results in a pile of ODBC driver HELL. BUT to answer your question, if your
going to use ODBC to get to Oracle, you'll have to have the SQL*Net client stuff
on that machine as well.
Dick Goulet
____________________Reply Separator____________________
Author: "James Damiano" <[EMAIL PROTECTED]>
Date: 7/10/2001 7:15 AM
Dear DBA Colleagues,
Please pardon me if this question is a bit elementary, but this concerns
applications connecting to Oracle.
Most of our Oracle Apps are PowerBuilder-based such that we use the
appropriate PowerBuilder DLLs and SQLNET on the Client to connect up to
SQLNET and the Oracle RDBMS on the server.
A new application we are proposing to build is Web-based, with Browser
clients connecting to a Linux (Red Hat 7.x) machine running Apache and Cold
Fusion. This Linux machine will then act as a client, connecting to the
Oracle 8i RDBMS running on a Compaq (DEC) Alpha with Digital Unix Version 5.
On the Linux box, we will of course need to specify the Cold Fusion DLLs to
allow connection to the Oracle 8i Database.
But my issue is this:
On the Linux machine running as the client, if we do "ODBC", do we need
to do SQLNET (Net 8) as well?
I.E. What is it on the client that actually makes the connection to the
SQLNET (Net 8) running on the server:
- "ODBC" itself <or>
- "ODBC through SQLNET"?
Thanks very much in advance!
Jim Damiano
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James Damiano
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
