Re: Microsoft Ole Db For Oracle and Windows NT 2000

I've tried it on my machine using WindowsXp and Ado 2.7 and it worked ok.

Are you able to post the connection string that you are using? This is the connection string I used "Provider=MSDAORA.1;Password=tiger;User ID=scott;Data Source=DEV"

Also what connection method are you using? (Local names, Oracle names server or Host names).

You might want to look at the Oracle Ole DB provider as well, it just to be a separate download, but I think you can only get it now packaged as part of the 8.1.7 client.

"Roberto" <robleo_at_iol.it> wrote in message news:wASH8.8129$8x3.182733_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 ?
>
>
Received on Thu May 30 2002 - 04:55:54 CDT