Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ODBC Connection to Oracle!
Dear Raji,
Please try to connect with the data direct driver and test the connectivity.
Best Regards,
Terminator.
raji s via DBMonster.com wrote:
> 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 - 06:22:40 CDT