Re: ODBC Drivers and Excel ver 5.0

From: Steve Jakob <sjakob_at_lrcc.on.ca>
Date: 1997/01/29
Message-ID: <5coesm$2qs@falcon.ccs.uwo.ca>#1/1

In article <01bc0a2d$70fa7700$8a1ca68f_at_127.0.0.1.us.dell.com>, Carlos_A_gonzalez_at_us.dell.com says...
>
>Oracle Gurus:
>
>I need your help PLEASE !!!
>
> <snip>
>
>My question is :
>
>I am using the wrong driver ?
>
>Should I be using the driver for windows 95 ?
>
>Any help will be greatly appreciated.
>
>Thanks
>
>Carlos
>

No, you should not use the Windows 95 driver. This is a 32-bit driver but Excel 5.0 is only a 16-bit application.

You failed to mention the connect string you used in setting up your new data source. The SQL*Net v2 format is as follows:

tns:db.server.world

where "db.server.world" is an entry in your TNSNAMES.ORA file (should be in a directory called /ORAWIN/NETWORK/ADMIN). For info on setting up the TNSNAMES file refer to Oracle docs. There should be a sample installed as part of the installation.

Good luck.

Steve Jakob
Programmer/Analyst
London Regional Cancer Centre
sjakob_at_lrcc.on.ca Received on Wed Jan 29 1997 - 00:00:00 CST