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
>
>
>
______________________________________________________________________
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
