Skip site navigation (1) Skip section navigation (2)

Odd odbc error message with excel et.al.

From: jwsacksteder(at)ramprecision(dot)com
To: pgsql-odbc(at)postgresql(dot)org
Subject: Odd odbc error message with excel et.al.
Date: 2004-01-26 19:59:27
Message-ID: 71650A6F73F1D411BE8000805F65E3CB3B38B2@SRV-03 (view raw or flat)
Thread:
Lists: pgsql-odbc
I am using pg_odbc version 07.03.0200 on WIN2000 to connect to to PG 7.3.2
on Linux. I use pgadmin3 for day-to-administration and am able to connect to
the databases with python scripts that use the odbc database interfaces.
However, when I try to connect using the 'get external data' function of
Excel(and implicitly, MSQuery)I get a error dialog that says 'blank' and an
'ok' button. Connections work fine with OpenOffice.org's spreadsheet. The
SQL logging function in the control panel gets me nowhere, as we are not
getting past the authentication phase when this happens and there is nothing
to log yet. Apparently, MSQuery is exercising the ODBC driver in a way that
the other tools do not. Since 'blank' is such a common word, google is less
than useful. Any suggestions to pin this down would be gladly accepted!


 

pgsql-odbc by date

Next:From: Aaron SpikeDate: 2004-01-26 23:08:46
Subject: Re: [HELP] MSAccess picks wrong keys
Previous:From: NellianDate: 2004-01-26 19:06:05
Subject:

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group