Hi,

On the current intranet project, we plan to use Visual Basic as our CGI
application language.  But I need to code the Visual Basic to log data
into our existing Oracle database on NT.

I have looked around bookstores (Barnes & Nobel, Super Crown, Bookstar)
trying to find a resource that can show me how to program the ODBC in
Visual Basic to link into our Oracle database.  All the books are major
on visual design with Visual Basic, and spending about 5 pages mention
the ODBC link, and not even mention how to program it.

Does anyone knows any place/book that I can find couple of examples of
how to program the ODBC link in Visual Basic? or someone has the sample
code I can learn from?

Any information is definitely help and greatly appreciated.

Thank you very much.

John

John,

I noticed the same thing when looking for some books on this subject a while
back.  I finally decided that the online books that come with Visual Basic
5.0 were a pretty good place to learn this.  They have the info you need to
connect to an ODBC data source using the DAO, RDO, ODBC API, and VBSQL API.
Look in the Guide to Data Access Objects and the Guide to Building Client /
Server Applications with Visual Basic Enterprise Edition (Part 3 - Data
Access Options).  Beware that Microsoft has decided the alphabet soup has
become too thick and is dropping support for DAO and RDO in the next VB
release.  We're supposed to all run to Active Data Objects (ADO) now.
There's info on this on the MS web site.  If you need to get something up
and going, I'd ignore the ADO propaganda for now and use RDO.  Check into
this and post some more detailed questions as they come up and we'll see if
we can provide some more guidance.

Hope this helps.

Michael Majors

All the books are major on visual design with Visual Basic, and spending
about 5 pages mention the ODBC link, and not even mention how to program it.

Does anyone knows any place/book that I can find couple of examples of how
to program the ODBC link in Visual Basic? or someone has the sample code I
can learn from?

John