Re: Visual Basic to Oracle 7.3

>If I want access my database from VisualBasic or Delphi which one is the
>better way to do it.

>
>Can I do it with SQL*Plus? or what should I do?
>

Hi Francisco,

I dont know about Delphi, but in case of using VB5, you should make use of the Oracle Objects for OLE (I got them along with Oracle 7.3 for NT). They consist of a Library and an OCX control. I prefer the Library (there's one for VB and a Class Library for Visual C++). The good thing about it is, that you dont have to deal with ODBC and other M$-specific stuff. Using the Oracle Objects, you connect to your database server directly via SQL*NET and I can tell you it s pretty fast.

You can use SQL*PLUS for Ad-hoc queries or to build PL/SQL scripts to use it later in your programming environment (Just the way I do it).

Have fun
Stefan Received on Fri Oct 02 1998 - 03:57:22 CDT