Re: connecting to Oracle/ODBC via winsock partly solved

Bill Meahan (wmeahan_at_ef0424.efhd.ford.com) wrote:
: In article <ace.74.0007A6D9_at_ics.forth.gr> ace_at_ics.forth.gr (Andreas C. Enotiadis) writes:
 

: >Also (correct me if I am wrong here - I am speaking from memory since I don;t
: >use ODBC) you should make sure you have the right ora6win.dll or ora7win.dll.
: >(My question here is if the ODBC driver uses OCI??). Anyway if it is needed
: >you should make sure your ODBC driver talks to right dll, i.e. the one in your
: >SQL*Net distribution.
 

: Yep - forgot to mention that. If you have Excel 4.0 on your system
: (especially if installed from shrinkwrap using mostly defaults) you will have
: an ancient version of ora6win.dll in your excel directory wihich Microsoft
: insists on putting near the beginning of your PATH string while Oracle adds to
: the end.
 

: Make sure you have ONE AND ONLY ONE oraXwin.dll and that it is the latest.
 

: --
: Bill Meahan, Senior Developer | wmeahan_at_ef0424.efhd.ford.com
: Electrical & Fuel Handling Division, Ford Motor Company
: "Computers are the most stupid machines in the world -
: they do EXACTLY what you TELL them to do!" (Gus Ogletree)

First thing you should do is get SQL*Plus, Oracle's standalone (bare-bones) query tool. It should be part of the Oracle package. THEN worry about ODBC.
One thing not to overlook is the Oracle configuration file (see Oracle setup info).

I had a hard time -- until I looked at the 'distribution' directory (can't remember the exact name), the one that contains the various .DLLs to distribute with the VC++ applications. Surprisingly enough, it contains a bunch of WinHelp files, one for each database driver. It also contains some text 'readme' files, including one for Oracle listing compatibility, files required, etc. It also talks about the Oracle initialisation file. (If interested, I could post it, but it's a bit long). Received on Fri Jun 17 1994 - 06:08:09 CEST