Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Connecting Excel to Oracle using ODBC

Re: Connecting Excel to Oracle using ODBC

From: Nicolas Bronke <newsgroup_at_trinity.de>
Date: Wed, 29 Sep 1999 14:48:13 +0200
Message-ID: <37f1ff0d@news2.prserv.net>

> Connecting from my machine(which has the development environment) works
fine
> without any problems. I fully developed the application from this setup.
> However, I am trying to deploy the Excel application on user machines. For
> this I need to configure the user machine. The users are running other
> Oracle applications, developed using Developer 2000(with native driver).
> So I would presume that SQL*Net 2.3 and TNS - Name are properly
configured.
> When I try to connect using ODBC, I get the error which is like SQLERR
text
> not found......
> This I guess is a function in one of the DLL's it is looking for.
>
> Please let me know if ODBC - Test program can be used even while using
> Microsoft ODBC driver for Oracle.
> (I would also give it a try)
> Obviously, I am new to the Oracle environment. Hope I have stated the
> problem clearly.
>

Sure. You can use the ODBC-Testprogram. Only if this program returns a successful connect, you can use ODBC via Excel. The Datei-DSN (File-DSN?) must be configured using the ODBC-Administrator-program.

Regards
Nicolas Bronke Received on Wed Sep 29 1999 - 07:48:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US