Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: ODBC Connection to Oracle!
raji s wrote:
>Hi,
>I am trying to connect to oracle database using a vb6 application. I have
>created a ODBC system dsn for oracle database using "Oracle in OraHome90" as
>the driver. Now using this ODBC Connection , I am trying to connect to the
>db using the connection string in the code. At the time of connecting , I
>also take the provider name along with it .
>Can anyone tell me what are the providers who actually support this "Oracle
>in OraHome90". I am able to connect to the db using provider - Microsoft OLE
>DB Provider for ODBC Drivers .
>
>However, I want to know if I can still connect using Oracle Provider OLE DB
>and Microsoft OLE DB Provider for Oracle. I am really stuck at this point and
>am unable to proceed further . Can anyone throw some light as to what is
>supported by Oracle 9.2
>
>Eagerly awaiting for your response.
>
>Thanks,
>Raji
I would like to add up to the above mail. When I try to connect using Microsoft OLE DB Provider for ODBC drivers, errors like ORA-12560: TNS: protocol adapter error. Received on Fri Jun 24 2005 - 05:59:57 CDT
![]() |
![]() |