I'm not an expert either and I am using 8i -- I have a "Microsoft ODBC for Oracle" driver and an "Oracle in OracleHomeDir" I am using the latter. I know my version is the latest one for 8i, but that is about it. Wish I could help more...
tim P. -----Original Message----- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 3:38 PM To: CF-Talk Subject: RE: CFMX Pro and Oracle? I'm going in thru the Windows ODBC control panel and using the Oracle driver that appeared there after I installed Oracle 9i. Is there some other way to do this? Another driver to d/l? I'm a complete Oracle newbie. --------------------------------------- Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc., www.mysecretbase.com --------------------------------------- ---------- Original Message ---------------------------------- from: "Tim Painter" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Wed, 17 Jul 2002 14:58:20 -0400 When you make the odbc connection, are you using the microsoft or Oracle driver? I'm using the Oracle driver here and have not had a problem with it. HTH, Tim P. -----Original Message----- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 1:01 PM To: CF-Talk Subject: CFMX Pro and Oracle? I'm trying to connect to an Oracle 9i db using CFMX Professional and a Windows ODBC socket connection. Is this possible or does it only work in Enterprise? I can make the Windows odbc connection, but CFMX is throwing errors trying to validate the datasource. I get this errmsg. Username, password, domain etc. are good. Connection verification failed for data source: OTEST []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists