Hmm, this is CF5 and oracle 8.1.7... I have done this once before with oracle 8, but it was on cf4.5, which had the native drivers page and was much easier <sigh>
~~ Stephenie > |-----Original Message----- > |From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > |Sent: Wednesday, September 04, 2002 6:08 PM > |To: CF-Community > |Subject: RE: Oracle Issues > | > | > |EXACTLY: > | > |Name Oracle73 Ver 2.5 > |Version 2.05.03.01 > |File SQO32_73.DLL > |Date 11/17/1998 > | > |This is actuall a patch to Version 2.5.3.1. > | > |We are running Oracle 8.1.6 but this works fine. > |BTW it's CF 4.5.1 SP 2 (Pro). > | > |-Ben > |> I first set up on inside the server in the odbc control panel...it > |> worked fine, so I went into cfadministrator and setup > |another one...it > |> didn't verify, but if I go into the odbc control panel and > |check the > |> one I setup in CF...it verifies....strange eh? > |> > |> Are you using CF5? This was a lot easier on CF4.5 (and > |about the only > |> that was) as it had the native drivers in CF... But CF5 doesn't... > |> > |> So what driver EXACTLY are you using? > |> > |> > |> > |> ~~ > |> Stephenie > |> > |> > |> > |> > |-----Original Message----- > |> > |From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > |> > |Sent: Wednesday, September 04, 2002 5:43 PM > |> > |To: CF-Community > |> > |Subject: RE: Oracle Issues > |> > | > |> > | > |> > |Stephenie, > |> > | > |> > |Did you set up the dsn in CF Administrator / Data > |> > |Sources / ODBC? > |> > | > |> > |Even though we're using the Oracle driver, not ODBC, > |> > |still had to go there, do that. > |> > | > |> > |Following the earlier example, pointed CF at "BLAH". > |> > | > |> > |-Ben > |> > | > |> > |> 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
