Re: Oracle ODBC driver and Microsoft Excel ver 5.0

In article <01bc0a2e$03d81f00$8a1ca68f_at_127.0.0.1.us.dell.com>, "Carlos A. Gonzalez" <Carlos_A_gonzalez_at_us.dell.com> writes
>Oracle Gurus:
>
>I need your help PLEASE !!!
>
>This is my problem:
>
>I am trying to reach an Oracle database on a remote host (Unix wrkstation)
>
>The client is an Excel Spreadsheet (Microsoft Query) ver 5.0 running in a
>PC under Windows 95.
>
>I can reach the remote server using SQL*Plus ver 3.2.2.0.1 and using
>SQL*Net ver 2.2.2.1.0 ==> no problem here
>
>I downloaded from http://www.oracle.com the following ODBC driver for WIN
>3.1
>
>Oracle7 ODBC(single byte) Driver ver 1.14.1.0.3
>
>This driver was setup correctly.
>
>Then from whithin Microsoft Query when I tried to add the ODBC data source
>I get the following error msg:
>
>ORA-12203: TNS: unable to connect to destination (Msg being put out by the
>driver)
> couldn't add data source.
>

This may mean that the relevant DLLs are not on the path. You need ODBC.DLL, and something like sqora7.dll and sqora7stp.dll (whatever came out of the Oracle package.

If you are using Excel 5 then make sure you are using 16-bit ODBC drivers.

-- 
Jim Smith