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 ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
