Re: Microsoft Ole Db for Oracle

"Roberto" <robleo_at_iol.it> wrote in message news:tCSH8.8132$8x3.183159_at_twister1.libero.it...
> My configuration:
>
> Windows Nt 2000 SP2
> Microsoft Ado 2.5
> Microsoft Ole Db Provider for Oracle
> Oracle Client 8.1.5
>
> I have the following problem with Microsoft Ole Db for Oracle:
> When I try to connect to a data source it gives the following error
> sometimes:
>
> "TNS: couldn't resolve service name"
>
> The connection works good with SQL PLUS and Net8 doesn't give to me any
> error (the connection work well)
>
> When I try to connect to Oracle with ODBC or OLE DB PROVIDER for ODBC I
> don't find problems
>
> I have installed then Oracle Client 8.1.7 and then Microsoft Ole Db for
> Oracle Work well ...why ?
>
>

You have multiple tnsnames.ora files on your system Please set up HKLM\software\oracle\tns_admin with the directory having the correct tnsnames.ora in it.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address