Kevin- thanks for pointing out about the login/pwd on the CF page. forgot to mention that, my bad.
-Ben > 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 > > |> | > > |> | > > |> | > > |> | > > | > > | > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
