Re: Software tool to develop front-end application (Visual Basic + SQL*Net)?

"Chung Ta" <ktdta_at_shaw.ca> wrote in message news:<%oQk9.403536$v53.18578661_at_news3.calgary.shaw.ca>...
> Hi all,
>
> I am a novice person in terms of developing a front-end database application
> using tools such as Visual Basic on the client pc accessing Oracle database
> running on the Unix server.
>
> I am familiar with Visual Basic as the front-end tool to access the database
> via ODBC or ADO method. These belong to the group of Microsoft technology.
>
> Somebody mentioned that I could use SQL*Net as the front-end software tool.
> But I don't know whether SQL*Net is a set of development tools that I can
> use to develop front-end database application.
> I am hoping that I can use Visual Basic in conjuction with SQL*Net but
> unsure if this is feasible. I am afraid that when I commit to SQL*Net I have
> to use SQL Form which is one of the development tool from Oracle and I am
> not familiar with this at all.
>
> Am I making sense in the question regarding Visual Basic and SQL*Net in
> developing a front-end database application?
>
> I would appreciate if someone can answer my question or point me to the
> direction where I could obtain further clarification.
>
> Thank you
> Chung

You have the ODBC driver for Oracle: runs on top of SQLnet. ADO/Oledb driver for Oracle: ditto
Oracle Objects for Ole (aka OO4O) : native DAO like API, interfaces with sqlnet.
*All products can be used from VB*
In all cases you need an Oracle client and/or additional sw. For development purposes you can download everything for free from http://otn.oracle.com or order the CD for $40 or the local equivalent from the Oracle Store

Hth

Sybrand Bakker
Senior Oracle DBA Received on Fri Sep 27 2002 - 16:09:01 CEST