Connect via Oracle Provider for OLE DB from Visual Basic CRASHES

From: J.L. PAUL <jlpaul_at_transiciel.com>
Date: 20 Jun 2001 00:22:01 -0700
Message-ID: <74d4afd7.0106192322.6dfce729@posting.google.com>

Hello,

I'm trying to use the Oracle Provider for OLE DB from VB, but unsucessfully !
Everything is OK with Microsoft OLE DB Provider for Oracle, but with the Oracle Provider it's impossible to connect.

Error received :
-2147467259-ORA-12154: TNS:Could not resolve service name

My <alias-user-password> works well with the SQL Plus utility.
The tnsping <alias> is OK.

Versions : oracle 7.3.4/OLE DB Provider 8.1.7.2.0/VB 6.0 sp4/NT 4.0 sp5

Any ideas ?
Thanks in advance, any suggestion will be appreciated.

Jean-Louis.

Here's the code :

.
.
.

Set mconConnection = New ADODB.Connection

With mconConnection
' this one is working well :

'         .ConnectionString = "Provider=MSDAORA.1;" & _
          "Data Source=" & sAlias & ";User ID=" & sUser & ";Password="
& sPwd & ";"
         .ConnectionString = "Provider=OraOLEDB.Oracle;" & _
          "Data Source=" & sAlias & ";User ID=" & sUser & ";Password="

& sPwd & ";"

.ConnectionString = .ConnectionString & "OSAuthent=0;PLSQLRSet=1;" .Open ' <---- it crashes here : ORA-12154

End With Received on Wed Jun 20 2001 - 02:22:01 CDT