Try creating a test page doing a basic query using the datasource set up to connect using 8i. It will give you a more detailed error than the verification in the administrator. That might help you pinpoint it.
----- Original Message ----- From: "David Hannum" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, October 22, 2002 7:27 AM Subject: Re: Oracle 8 Native Drivers Failing > The TNSNames.ora file is fine. Oracle, Merrant and Microsoft ODBC all > connect and run, the 7.3 Native Drivers connect and run, SQL Plus connects > and runs. The Oracle 8 Native Drivers fail verification. > > Dave > > > ----- Original Message ----- > From: "Catherine Taylor" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, October 21, 2002 10:04 PM > Subject: Re: Oracle 8 Native Drivers Failing > > > Well, not seeing your system, my guess is that your ORACLE_HOME > environment is set to the wrong location for using the native drivers on > the W2K system. Can you connect to the database using SQL-Plus 8i > version from the W2K server? If not, then once you resolve that you > should be able to connect via CF. I ran into that once when I had both > versions of Oracle client on my system. > > Hard to say. Does your connection actually fail verification or is it > just some features don't work? > > Cathy > > On Monday, October 21, 2002, at 05:04 PM, David Hannum wrote: > > > We have CF 5.0 on Win2K SP3 and Oracle 8.1.6 (8i) on Solaris. We cannot > > connect to the database using the Native 8.0 drivers. The 7.3 drivers > > work > > except for CFQUERYPARAM which the 7.3 drivers do not seem to support > > and we > > cannot do without. Does anybody have experience in this area? Why > > doesn't > > the native 8.0 drivers work? > > > > Dave > > > > =============================== > > David R. Hannum > > Web Analyst/Programmer > > Ohio University Computer Services > > Administrative Systems > > (740) 597-2524 > > > > "If your wife is having fun, and you're not . . . > > You're still having a lot more fun than if > > you're having fun, and she's not!" (Red Green) > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
