RE: Client Connection-SQLNET and?/or? ODBC.
Yes you need SQLNET. odbc uses sqlnet on the client. -Original Message- Sent: Tuesday, July 10, 2001 10: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 itselfor - 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: Shaw, John B 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).
RE: Client Connection-SQLNET and?/or? ODBC.
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 itselfor - 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: Robin Ilardi 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).
RE: Client Connection-SQLNET and?/or? ODBC.
Hello James, Every ODBC connection I've seen or used has connected through SQL Net (i.e,., app-odbc-sqlnet-database). But ODBC isn't really my area of expertise... Jay Miller -Original Message- 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 itselfor - 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: Miller, Jay 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).