From ilardir@mantech-wva.com Tue, 10 Jul 2001 09:41:45 -0700 From: "Robin Ilardi" Date: Tue, 10 Jul 2001 09:41:45 -0700 Subject: RE: Client Connection-SQLNET ?/? ODBC. Message-ID: MIME-Version: 1.0 Content-Type: text/plain Yes, you do need to have Net8 installed in order for Cold Fusion to connect to the database through ODBC. It uses ODBC through SqlNet. First set up the Sqlnet connection to the database, then set up the ODBC connection using the service name you used for the Sqlnet connection. hth, Robin -----Original Message----- Damiano Sent: Tuesday, July 10, 2001 11:15 AM To: Multiple recipients of list ORACLE-L 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 - "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: jadam@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@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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robin Ilardi INET: ilardir@mantech-wva.com 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@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).