Re: Accessing Oracle Server through VB 3.0 for Windows

(Pundarik Ranchod) writes:
> Hi all,
>
> I am trying to access our Oracle Server (version 6) which is installed
> on a SUN from Visual Basic 3.0 for Windows.
>
> SQL*Net for DOS has already been installed and works perfectly under FTP Inc.
> PC/TCP Ver 2.03. The file ORACLE.TXT that comes with VB 3.0 Professional
> Edition explains how one would go about setting up the drivers required
> for VB inorder to connect to the Oracle database.
>
> The ORACLE.TXT file mentions SQL*Net for Windows ver 1.1.7.5. Do I now
> need to purchase this product ? Is there no way that SQL*Net for DOS will
> work under Windows.
>
> Any help will be appreciated.
>
> Thanks for your time.
>
> Cheers,
> Pundarik

If you can give a little more information, perhaps I can help out. Are you tring to access Oracle via SQL*Net directly or are you going through an intermediate set of libraries (Oracle Glue, Q+E Database Library etc...)? How do you know that the SQL*Net for DOS that you are running is actually working? Are you going through that directly or with another product (SQL*Plus, SQL*Forms, etc...)?
I have been using VB 3.0 and SQL*Net for DOS to access Oracle on a VAX database server (via the two libraries mentioned above) and the only thing that would need to change for your platform should be the connect syntax. So let me know what you are tring to do and if this is close.

-- 
 /---------------------------------------------------------------------------\
 | Andrew Dowswell     | "...They bring me numbness in their bright needles, |
 | Parke-Davis (CPO)   |  they bring me sleep. Now I have lost myself..."    |
 | dowswea_at_aa.wl.com   |                                                     |
 | (313) 996-1337      |             Sylvia Plath "Tulips"                   |
 \---------------------------------------------------------------------------/
 Disclaimer: The opinions of Parke-Davis are not necessarily my own, they
             should not be construed as mine and no flames should be directed 
             at me for something Parke-Davis has said or done.