RE: Help! can't get Oracle connection

2004-04-04 Thread Joe Eugene
nt: Sunday, April 04, 2004 6:49 PM   To: CF-Talk   Subject: Re: Help! can't get Oracle connection   If I recall what I was told correctly, you had to be running the Enterprise version of CFMX to support Oracle with direct drivers -- hence the reason going with the ORA92 ODBC drivers for versio

RE: Help! can't get Oracle connection

2004-04-04 Thread Dave Watts
> If I recall what I was told correctly, you had to be running > the Enterprise version of CFMX to support Oracle with direct > drivers -- hence the reason going with the ORA92 ODBC drivers > for version 9.2 of Oracle -- I am running CFMX > Standard/Professional or what it is now called and it

Re: Help! can't get Oracle connection

2004-04-04 Thread Arden Weiss
If I recall what I was told correctly, you had to be running the Enterprise version of CFMX to support Oracle with direct drivers -- hence the reason going with the ORA92 ODBC drivers for version 9.2 of Oracle -- I am running CFMX Standard/Professional or what it is now called and it works great wi

RE: Help! can't get Oracle connection

2004-04-04 Thread Dave Watts
> Would you tell me how to set up the JDBC driver? There's very little to it. If you're using CFMX Enterprise, just select "Oracle" from the database list within CF Administrator, then fill in the blanks appropriately. You don't need to install the Oracle client beforehand to use this. If you don

Re: Help! can't get Oracle connection

2004-04-04 Thread Arden Weiss
Which version of Oracle are you running -- what I did for Oracle 9.2 is download the ORA92 ODBC driver from Oracle (the one with CFMX is for Oracle 8  I believe) and installed it. Next I went to the Control Panel/Administrative Tools/Data Sources (ODBC). In this screen click on the System DSN tab

Re: Help! can't get Oracle connection

2004-04-04 Thread Jim Watkins
Would you tell me how to set up the JDBC driver? Jim Watkins   - Original Message -   From: Joe Eugene   To: CF-Talk   Sent: Sunday, April 04, 2004 5:13 PM   Subject: RE: Help! can't get Oracle connection   Why NOT just use the JDBC Driver that comes with Oracle Or   the one

RE: Help! can't get Oracle connection

2004-04-04 Thread Dave Watts
> I have installed CF 6.1 professional on Win 2003 and > installed the Oracle 9i client. Created the TNS names > file and datasource. Used the MS ODBC Data Source > Administrator on Win2003 and created the Oracle ODBC > Driver Configuration and tested connection good. My > problem: > > The Or

RE: Help! can't get Oracle connection

2004-04-04 Thread Joe Eugene
Why NOT just use the JDBC Driver that comes with Oracle Or the one that comes with CFMX. The JDBC driver is much more stable and faster... from tests i did a while ago. HTH Joe Eugene   -Original Message-   From: Jim Watkins [mailto:[EMAIL PROTECTED]   Sent: Sunday, April 04, 2004 12:58 PM