Are you using the Oracle Client? Did you reboot after installing the Oracle client? I had a similar issue awhile back and a reboot solved it.
~~ Stephenie Hamilton Macromedia Certified ColdFusion Professional CFXHosting -----Original Message----- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 12, 2003 3:38 PM To: CF-Talk Subject: CFMX & Oracle native DSN issues I can't for the life of me get an oracle native DSN properly configured in CFMX. I have my tnsnames.ora file open and am copying the SID, server, port, username, password, etc. verbatim, yet I cannot get the connection to verify correctly. The error message I'm getting is: Connection verification failed for data source: ora_i18n []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. Has anyone had this problem, and what was your solution? Is CFMX just picky about the format of a tnsnames.ora file? Thanks Pete ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
