Re: Oracle7.3 and MS-Query 8.0

We use Oracle ODBC driver version 2.5 with success. However, if the test can connect to the database, then MS-Query should also work. Are you sure you provide the correct SQL connect string when logging in with MS-Query ???
I also remember that with earlier versions of the ODBC driver I could not connect to any database, except the one specified in the "local" string in the Oracle section of the Registry. If I wanted to connect to another database, I had to change this parameter. Does this one exist in your installation ??? It is not set by default.

Hanns Heiss wrote:
>
> We want to get data from a Oracle-Server (7.3, Dec-UNIX) via MS-Query
> into MS-Word (for mail merge).
snip
> For this we need a ODBC-driver to Oracle for WindowsNT 4. With our
> driver from Oracle (Version 2.03) this does not function. MS-Query puts
> the error-message "Unable to connect to database-server.
snip

-- 
******************************************************************
***** A L C A T E L  B E L L  S P A C E                    *******
Herman Viaene
Berkenrodelei 33, B-2660 Hoboken, Belgium
Tel: (32/3)8295591
Fax: (32/3)8295502
OIS-mail: viaeneh_at_AM_at_BTMA97
Internet-mail: viaeneh_at_btmaa.bel.alcatel.be
X400: Viaene Herman (C=BE,A=RTT,P=ALCANET,OU1=BELA1,O=ALCATEL,
S="Viaene",G="Herman")
******************************************************************