Thread: Connecting VB with oracle

hello all

I am trying to connect visual basic and oracle but unable to connect it. I am using oracle 10g. I am able to connect to oracle 9i. Can anyone tell me How can i connect to oracle 10g?

I Dont want to use DSN connection

Thanks in advance for any help

does it have an ODBC driver?

hxxp://www.oracle.com/technology/software/tech/windows/odbc/index.html

might not have the updated ones?

If its not that, i'm clueless! sorry! never had the opportunity to work with oracle!

first install odbc in your pc then check it

Microsoft and Oracle don't get along too well.
I did program some apps years ago in vb6 to connect to Oracle 8i and 9i.

The trick was to use the OO4O (Oracle Object for Oracle), but it was painful as I needed to code all the recordset behaviors in a class module. Oriented object basically.

use odbc bridge