Re: Connecting Excel to Oracle using ODBC

Hi Ananda,

  It's ver simple. Locate a product called 'Oracle ODBC' distributed by Oracle on some client CD's (like D2K for Windows) else go to http://technet.oracle.com and get it from there. Just install it on your machine and it will appear under 'Oracle for Windows 95' in Start menu.

   Set up your tnsnames.ora file properly and ensure that u can first connect using SQL*Plus (This has to work first since SQL*Plus has no connection with ODBC at all).

   Once SQL*Plus can connect, go to the 32-bit Administrator and create a new ODBC source using the newly-installed driver from Oracle. use this connection, it will work with Excel. Youcan check this too by first trying from MS-Query.

HTH,
Chetan
Bangalore, India

Anand Kakarala wrote in message <7sbjtu$kj6$1_at_bgtnsc02.worldnet.att.net>...
>Hi All,
>
> I am trying to connect Excel to Oracle using Microsoft ODBC
>driver(msorcl.dll).
>Oracle, version 7.3 running on an UNIX box. SQL*NET is on the network and
>EXCEL along with msorcl.dll is on the local machine.
>
>It would be of great help, if someone could let me know what are the files
>required to make this connection.
>I could find documentation on using the ODBC driver from oracle,
>however, what I need is for the Microsoft ODBC driver.
>
>Thank You in advance
>
>David Jude
>
>
>
>
>
>
Received on Thu Sep 23 1999 - 00:24:15 CDT