Re: queries to ORACLE from VB5?

Hello,

If memory serves, using ADO requires the Jet engine. But you can bypass it by using ODBC.
I've never used the Oracle driver, but the Microsoft driver has never given me a problem.

I'm using ODBC from VB5 to connect to Oracle (and DB2, Access, SQL Anywhere and SQL Server). In ODBC you can send queries to Oracle by connecting to it and using SQLExecDirect to send it SQL queries. If you haven't had much C experience, I wouldn't recommend going this route. In that case, ADO or RDO would be a safer bet.

Just one thing to watch out for:
One of my coworkers is using ADO with MFC and is having problems retrieving multiple records using dynasets in Oracle 7.3

carloMarx wrote in message <6s7ec7$hl5$1_at_news.onramp.net>...
>Do queries to an Oracle server made from programs written in VB5 have to be
>passed through the JET database engine on the local machine (which means
the
>engine
>has to be there?) or is there a way to send queries directly to Oracle?
>How do the drivers provided by the Oracle client and the one that VB can
>install compare with one another?
>Safer to go with the Oracle one? What about distributing the app to
>relatively lean client machines?
>
>How do you interface a VB app directly with an ORACLE server?
>dao? rdo? odbc? activeX?
>
>Thanks for entertaining my questions.
>
>
Received on Sun Sep 20 1998 - 06:09:21 CEST