Re: connecting to Oracle/ODBC via winsock partly solved

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)