If you can verify through ODBC, your tnsnames.ora and all the NET8 and Oracle client settings are fine.
There are native drivers for the CF 5 but only for the enterprise version. Are you running the Pro version? Regardless, you should still be able to connect on CF's ODBC page. In the CF ODBC page, make sure you enter the oracle SID and not the name of the DSN you created in the ODBC control panel applet (the SID was defined in the tnsnames.ora file) into the Server name field when you create the DSN on the CF page. Also make sure you hit the CF settings button when you create the DSN so you can enter the username and password for the oracle connection. It'll definitely fail without the login info. I've only ever worked with native drivers on Solaris so I can't be of much help, sorry ! -----Original Message----- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 9:54 AM To: CF-Community Subject: RE: Oracle Issues There is no native driver page in CF5..which is the version we are running for this client. We can verify the DSN's through ODBC control panel....just nothing willwork with CF ~~ Stephenie > |-----Original Message----- > |From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > |Sent: Wednesday, September 04, 2002 6:29 PM > |To: CF-Community > |Subject: RE: Oracle Issues > | > | > |We've used the native driver option to connect to oracle. > | > |Follow this path of instructions for WIN 2k > | > |Start > program files >Oracle - orahome81 > network > |administration > Net8 > |Configuration Assistant > | > |Choose local net service name configuration > next > |choose test > next > | > |Select from available list to test connection > next > | Note: If database not listed then go back and add > |If there continue > | > |Most likely the test did not succeed > select change login > | > |Provide credentials (username and password) > OK > | > |Hopefully test was successful > next > | > |Name service name configuration complete > next > finish > | > |--------------------------- > | > |At this point you have verified that the oracle client can > |connect to the > |database : - ) > | > |-------------------------- > |Next Verify with CF Administrator... > | > |Login to CF administrator > | > |Select native data sources. > | > |EDIT or Add DSN selecting oracle80 driver > | > |Provide hoststring and coldfusion login username, password > |(login used to > |test in the example above) > update > | > |Hopefully this worked. > | > |If not, usually the problem area is the host string. Verify your > |hoststring information in cf matches the service_name found in you > |tnsname.ora file. > | > |-Robert Mann > |Senior Web Specialist > |Kaiser Permanente > | > | > | > | > | > | > | > | > |"Stephenie Hamilton" <[EMAIL PROTECTED]> > |09/04/2002 02:37 PM Please respond to cf-community > | > | > | To: CF-Community <[EMAIL PROTECTED]> > | cc: > | Subject: RE: Oracle Issues > | > | > |Yes the oracle client is on the server, vs is Oracle 8.1.7 > |The client can connect, we have verified this by using the > |little test utility, as well as verifying the DSN through > |the ODBC control panel (one dsn created with MS oracle > |driver, the other with the Merant driver that comes with CF) > |Both verify inside windows, but fail in CF > | > |~~ > |Stephenie Hamilton > | > | > | > |> |-----Original Message----- > |> |From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]] > |> |Sent: Wednesday, September 04, 2002 5:31 PM > |> |To: CF-Community > |> |Subject: RE: Oracle Issues > |> | > |> | > |> |This can be a real bear to deal with sometimes. > |> | > |> |Have you installed the Oracle client on the machine (not ODBC)? > |> | > |> |What version of Oracle are you using? > |> | > |> |-----Original Message----- > |> |From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] > |> |Sent: Wednesday, September 04, 2002 5:02 PM > |> |To: CF-Community > |> |Subject: Oracle Issues > |> | > |> |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! > |> | > |> |~~ > |> |Stephenie Hamilton > |> | > |> | > |> | > |> | > | > | ______________________________________________________________________ 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 Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
