Re: ODBC via Visual Basic to ORACLE v7
Date: 9 Nov 1994 14:19:29 GMT
Message-ID: <39qlph$3a9_at_xenon.brooks.af.mil>
In article <39o86l$ah9_at_sdu003.sandwich.pfizer.com>, betts_nm_at_pfizer.com () says:
>
>
>Subject says it all,
>I'm trying to use Visual Basic + ODBC to get info out of an ORACLE v7 database,
>any ideas/suggestions where to start.
>
>I have little experience with ODBC and little experience with ORACLE but I do
>have a DB Administrator to help me out with the ORACLE bit!
>
>
>HELP
>
>Many Thanks,
>
>Nic Betts
>(Everything Expressed is My-Opinion Only (C))
Nic,
We have written a couple of apps in VB talking to Oracle 7.0.16. Your most logical starting place is SQL*Net for windows. If you don't already have a copy, I would suggest that you get 1.1.7.10.4, as previous version have bad side effects (i.e. they don't seem to work).
From there you can go into your control panel and configure your ODBC connection.
Two suggestions:
1) Take a serious look at Q+E Multilink VB (I don't work for them)
but their product provides MUCH better data handling widgets (controls)
than the VB product alone. They also give you ODBC drivers for Oracle6&7.
2) If you experience Oracle errors like -9042 or -6105, 6106, try adding the port number to your connection string (from the server's "/etc/services" file) which should be:
orasrv 1525/tcp #SQL*Net
This will give you a connect string which looks something like:
T:machine/1525:sidname
Please note that this is presumming a UNIX server (I'm rather UNIX-centric), If your connecting to a VAX, we've done that too, let me know 'cause its a bit different.
Richard Wark warkr_at_vanadium.brooks.af.milComputer Science Corporation,
Brooks AFB, San Antonio, Texas Received on Wed Nov 09 1994 - 15:19:29 CET