| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re:Client Connection-SQLNET <and>?/<or>? ODBC.
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" <jadam_at_nhes.state.nh.us> 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:
Thanks very much in advance!
Jim Damiano
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James Damiano
INET: jadam_at_nhes.state.nh.us
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: ListGuru_at_fatcity.com (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).
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: ListGuru_at_fatcity.com (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). Received on Tue Jul 10 2001 - 11:25:36 CDT
 |
 |