ODBC Connection to Oracle!

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 Received on Fri Jun 24 2005 - 05:53:56 CDT