Re: Connect via Oracle Provider for OLE DB from Visual Basic CRASHES

If you have multiple Oracle homes, check to be sure the tnsnames.ora file is the same in each..or set a TNS_ADMIN key in the registry ( details if needed on request) to specify the location to use... The Microsoft provider and the Oracle provider may be 'looking' in separate homes ( depends on the version)..
If you have only one home,. then I guess its an Oracle provider failure ( Not all that surprising, ODBC and OLE drivers have not been their long suit)

jlpaul_at_transiciel.com (J.L. PAUL) wrote:

>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

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Wed Jun 20 2001 - 08:45:30 CDT