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 > |> | > |> | > |> | > |> | > | > | ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
