Re: interface between Visual Basic and Oracle

In article <27130_at_rnd.GBA.NYU.EDU> atuzhili_at_rnd.GBA.NYU.EDU (Alexander Tuzhilin) writes:
>I'm trying to develop an application using a full-fledged relational
>database on a PC under MS-Windows. The application must therefore have
>a nice Graphical User Interface (GUI). I was thinking of using Oracle
>as the database and Visual Basic as the programming language since it
>has a nice GUI. Does anyone have any experience using the two
>together?
>

Yes. You can write in Visual Basic and use Oracle for Windows. OFW has a DDE Manager component. The DDE Manager is a DDE server that runs in its own window. It allows you to send SQL to Oracle using the DDE protocol and receive data back into the program. Works very well for small amounts of data. I haven't got any experience trying it on large amounts of data, however.

I've placed a sample application and a technical paper on the Oracle Forum (GO ORACLE) on Compuserve. Look in section #1 for VBDDEM.EXE.

I have a library of VB calls in there
that isolates all of the DDE nastyness from your code. If you like I can email you the source (it's not long) to these calls. If there is sufficient interest I can post it here, as well.

  Mark D. Richter, Architect
  Oracle Desktop Products
  Box 659409
  500 Oracle Parkway
  Redwood Shores CA 94065
  CIS: 70400,3514

Mark D. Richter                                             1.415.506.4852
Oracle Corporation, Desktop Products Division       mrichter_at_us.oracle.com

------------ "Unlike leadership, golf builds character."------------------