Re: Visual Basic to PO7

In article <3qq3qe$tdl_at_news.admu.edu.ph>,

   jrilagan_at_admu.edu.ph (Joseph Benjamin R. Ilagan) wrote:
>SHEN ZHIJIA (shen_at_spot.Colorado.EDU) wrote:
>: Hi, netters, has anyone used visual basic to talk to Personal Oracle 7?
>: Any help on this will be appreciated.
>
>You can make Visual Basic talk to Oracle through either the Data Control VBX
>(via ODBC) or the Oracle Objects for OLE interface. With Oracle Objects for
>OLE, you have the option of either using OLE2 programming or using the Oracle
>Data Control VBX, which is similar to the Data Control VBX shipped with
>Visual Basic 3.0 and hides most of the complexity of OLE2 programming.
>
>No SQL*Net is needed if you intend to run your Visual Basic application
>against a Personal Oracle 7 database on the same machine.

Another advantage of PO7 is that you CAN use the programs which come with PO7 on an Oracle 7 database which is accessed using SQL*Net. I especially like some of the management utilities which greatly simplify some of the mundane Oracle 7 DBA tasks.

• Jim