The service_name in this case is the SID. Use the service_name, in this case ctlg.world in the server name field.
The setup is pretty much identical whether it's ODBC or Native. I just set up an ODNC DSN on our Solaris Enterprise dev box there now. -----Original Message----- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 10:21 AM To: CF-Community Subject: RE: Oracle Issues We are running CF5 Pro..... I just looked at the tnsnames files and there are 3 listings in there...but no SID for each listing... --Sample-- GSWEB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = IPHERE)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ctlg.world) ) ) --endsample-- So does there need to be an SID entry made into this? And you are saying us the SID entry to be the DSN name instead of what I entered in the odbc control panel (even though that one shows up in CF Admin/odbc)? Thanks for the help, this oracle crap is driving me crazy! Also, would this be easier in cf5 enterprise due to the native driver support? ~~ Stephenie Hamilton Macromedia Certified ColdFusion Professional > |-----Original Message----- > |From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]] > |Sent: Thursday, September 05, 2002 10:03 AM > |To: CF-Community > |Subject: RE: Oracle Issues > | > | > |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 > |> |> | > |> |> | > |> |> | > |> |> | > |> | > |> | > | > | ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Archives: http://www.mail-archive.com/cf-community@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
