Ok, well the oracle dba (for the client I am working with) said the tsnames file is all setup. I am assuming it must be or none of the dsn's would verify thorugh the odbc control panel...right?
Now do we have to add an entry to this file for each dsn we want to create? I didn't think you had to do that... ~~ Stephenie > |-----Original Message----- > |From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > |Sent: Wednesday, September 04, 2002 5:29 PM > |To: CF-Community > |Subject: Re: Oracle Issues > | > | > |Stephenie, > | > |There's a file Oracle uses named tnsnames.ora which > |contains connection information for databases (host > |name, port, SID, etc. I put a copy of the file on the cf > |box. (in c:\orant\network\admin). > | > |Also have the Oracle SQL*Net client installed on the CF > |box. > | > |Sample tnsnames block: > |BLAH.world = > | (DESCRIPTION = > | (ADDRESS_LIST = > | (ADDRESS = > | (COMMUNITY = tcp.world) > | (PROTOCOL = TCP) > | (Host = 123.45.678.90) > | (Port = 1521) > | ) > | (ADDRESS = > | (COMMUNITY = tcp.world) > | (PROTOCOL = TCP) > | (Host = 123.45.678.90) > | (Port = 1526) > | ) > | ) > | (CONNECT_DATA = (SID = BLAH) > | ) > | ) > | > |Am using the Oracle driver. > | > |In ODBC setup on the CF box, in this example, the Data > |Source Name would be BLAH, and the SQL*Net Connect > |String would be BLAH.world. > | > |HTH. > | > |-Ben > | > | > |> 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 > |> > |> > |> > | ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
