Re: VB5 and Oracle 7.3 ...

From: Robert Clevenger <robc_at_magicnet.net>
Date: 1998/02/18
Message-ID: <6cfqfi$9o8$1_at_comet3.magicnet.net>#1/1


Eric,

Another problem is deciding how you want to connect to Oracle.

There are 2 main ways of doing this with Visual Basic.

  1. ODBC - Get the Oracle ODBC Driver for Windows NT/95 or get the Microsoft ODBC Driver for Oracle (2.73 preferred)

 Then use one of the libraries that come with VB   DAO - Data Access Objects
  RDO - Remote Data Objects (Only in the enterprise edition)

2) Oracle Objects for OLE

    Available on the Oracle Client CD and Programmer/2000.

Personally, I use Oracle Objects for OLE. I don't care for DAO and RDO that much (Not against Oracle at least)  DAO seems to unintelligent with Synonyms and RDO wants too  studdley of an ODBC Driver (i.e. scrollable cursors which only  the Intersolv and Simba ODBC drivers support. (They both charge  for their ODBC drivers while MS and Oracle do not.)

It's all a matter of preference as to how you want to do it however.

Take Care,

Robert Clevenger

Eric Latour wrote in message <6cf0ui$dqg$1_at_news1.tor.acc.ca>...
>Hi ..
>
> I have a problem .. I want connecting my program in VB5 to an Oracle
>database ... the problem is ... how to do ?
>
> I would like more informations or references on this problem.
>
>My VB5 is on a platforms Win95/NT 4.0
>And
>Oracle 7.3 is on Digital DEC Alpha (Unix)
>
Received on Wed Feb 18 1998 - 00:00:00 CET

Original text of this message