Are you sure that the SQLNET.ORA and TNSNAMES.ORA files are valid and in the proper directory on the CF5 server? Normally, they are in <oracle_directory>/NET80/ADMIN. As a CF developer new to the "Oracle way of things", I was totally confused by these files and finally had to ask the Oracle Admin to set them up for me, so if you don't know anything about these files, ask the DBA for help!
Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com > -----Original Message----- > From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 05, 2002 10:10 AM > To: CF-Talk > Subject: RE: Oracle and CF5 > > > We have the oracle client installed, the DSN's will verify from the > windows ODBC control panel, from sqlcon32.exe and from the oracle test > utility. Just not inside CF.... > This is CF5 Pro > > ~~ > Stephenie > > > > > |-----Original Message----- > > |From: David Hannum (Ohio University) [mailto:[EMAIL PROTECTED]] > > |Sent: Wednesday, September 04, 2002 5:57 PM > > |To: CF-Talk > > |Subject: Re: Oracle and CF5 > > | > > | > > |Have you installed the Oracle client on the server? We're > > |running CF 5 on Win2K against Oracle 7.x & 8.x servers on > > |IBM, AIX and Sun boxes. Not a problem (except for one issue > > |on the IBM). But, you need the Oracle client installed on > > |the server and you need a properly written TNS Names file > > |(tnsnames.ora) that the Oracle drivers can find. If this > > |isn't enough info, I'll be glad to expound further. > > | > > |Dave > > | > > |===================== > > |David Hannum > > |Web Analyst/Programmer > > |Ohio University > > | > > | > > | > > |----- Original Message ----- > > |From: "Stephenie Hamilton" <[EMAIL PROTECTED]> > > |To: "CF-Talk" <[EMAIL PROTECTED]> > > |Sent: Wednesday, September 04, 2002 5:03 PM > > |Subject: Oracle and CF5 > > | > > | > > |> I have a client who is running a dedicated CF5 server and > > |a dedicated > > |> Oracle server. We can't get CF to talk to oracle. The > > |dsn's we setup > > |> in the ODBC control panel verify, but not through CF and > > |CF tells me > > |> "ODBC Error Code = IM003 (Specified driver could not be loaded) > > |> > > |> > > |> Specified driver could not be loaded due to system error > > |126 (MERANT > > |> 3.70 ColdFusion OEM 32-BIT Oracle8). " > > |> > > |> Neither the DSN with the merant driver nor the dsn with > > |the ms oracle > > |> driver will verify through CF administrator... > > |> > > |> Anyone know anything about this? This is my first time > > |dealing with > > |> oracle and it is driving me crazy! > > |> > > |> Oh yeah, this is a Win2k server > > |> > > |> ~~ > > |> Stephenie > > |> > > |> > > |> > > | > ______________________________________________________________________ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
