Re: Connecting with VB

Frank_at_OsborneConsulting.com wrote:

> We are starting a project using vb6 and Oracle 8i
> and seem to have 3 options for connecting to
> Oracle from VB.
>
> 1. ADO + Oracle ODBC Driver
> 2. ADO + OLE Db (Microsoft Oracle ODBC Driver)
> 3. Oracle Objects 0040
>
> Oracle Objects looks slick but most of the books
> seem to indicate that it is the least used method.
> Does anyone have strong reasons for using one over
> the other?

ADO + ODBC in Vb is probably not a good idea in most cases because you simply don't need the extra layer that is used with ODBC.

ADO + Microsoft OLE DB driver for Oracle is my personal choice because sometimes I'm going against oracle and sometimes against SqlServer and in many cases the only thing I have to change is the connect string.

OO4O is nice and fast, but it makes your code totally unusable for other purposes and it represents a different syntax then ADO.

I'd say go with ADO and Microsoft OLE DB driver or Oracle and really learn it thoroughly. That way if you ever have to switch to another database the learning curve is smaller. Microsoft is constantly improving their drivers and if you keep up with the changes you'll probably end up prefering to stick with that technology. Received on Fri Sep 15 2000 - 14:41:04 CDT