Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Connect via Oracle Provider for OLE DB from Visual Basic CRASHES
jlpaul_at_transiciel.com (J.L. PAUL) wrote in message news:<74d4afd7.0106192322.6dfce729_at_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
I don't believe you can install the OLE DB provider on top of an Oracle7 client. I believe you have to have at least an 8i client.
Justin Cave
>
> 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 Sat Jun 23 2001 - 14:10:44 CDT