Re: ORACLE 6/7 ODBC Access

In article <2kdlf7$q3h_at_reeve.research.aa.wl.com>, ditommm_at_aa.wl.com writes:
>
> I am able to connect to ORACLE (VAX/VMS v.7) using SQL*Net for Windows and
> NetManage Chameleon TCP/IP for Windows by way of ODBC, HOWEVER - it is
> unbelievably slow! Is ODBC/ORACLE worthless? I was hoping to develop Visual
> Basic applications that access corporate ORACLE databases. Also, I cannot
> access ORACLE v.6 only ORACLE v.7 - v6 connect attempts fail giving error
> ORA-6105??? The ORACLE ODBC driver that I am using is the one that comes
> with MS Access - is there a better on somewhere?
>
> Thanks in advance,
>
> Matteo diTommaso |
> ditommm_at_aa.wl.com |
> (313) 996-7148 | This space for rent.
> Full disclaimer available via e-mail! |

Q+E Software sells an ODBC Driver Pack for $199 (US) that includes pretty good drivers for both Oracle 6 and Oracle7, plus about a dozen other drivers, like Sybase, Ingres, Paradox, DB/2, etc. Also, Oracle is working on a driver which may be available in the next couple of months as part of a new 'connectivity' product.

I haven't done any real timing tests, so I don't know if the Q+E driver is faster than Microsoft's, but I find it more flexible, and overall easier to work with.

Also, as I recall, Microsoft's driver is for Oracle 6, with unsupported access to Oracle 7. I'm not sure why you can't connect to Oracle 6, but you shouldn't rely too heavily on the Microsoft driver for Oracle7 access.

-- 
The above statements are not the opinions or policies of SPSS Inc.
The above statements may not be the opinions of Brent Lambert.
The first disclaimer is a policy of SPSS Inc.
Subsequent disclaimers are probably the opinion of Brent Lambert.