RE: MS-Query

Can you access other data sources via MS-Query, such as local Access
databases, or possibly remote MSSQL server databases? I can't think
of any reason why MS-Query should be crashing...

Mike Mascari
mascarm@mascari.com

-----Original Message-----
From:    Ludwig Meyerhoff [SMTP:ludwig@antar.com]
Sent:    Thursday, May 03, 2001 3:53 PM
To:    pgsql-general@postgresql.org
Subject:    [GENERAL] MS-Query

Hallo!

Here I post the question again ...

I have installed Postgres 7.1 from source on my DLD computer.
Everything works fine, as I have access with my Perl-Scripts (after
having
updated the appropriate Perl-module).

Now, I wanted to access the database to insert some data in Word
(multiple
letters), so I installed the psqlodbc-07_01_0004 on the client,
StarOffice
at least can access the database structure before complaining about
something (missing permissions, I suppose).
What Staroffice says does not matter, as I wanted to access the
database
from Word. So in Word I selected "Extras", "Serienbrief" and created
a
multiple letter from the actual document, selected as source "MS
QUERY",
as that seems the only sensible thing to choose in a "FILE/OPEN" menu
to
access a server (and not a file).
In MS-Query I created a new connection using the Postgres-ODBC
driver,
configured it to access my server - and as I click on OK MS-Query
breaks
down ("crashes" is maybe a better word) leaving me a messaage about
unrecoverable errors at 2374827432374 and asking me whether I wanted
to
see more details or to close the warning-message.
On the client-side I run Win98 with Office 97 SBE, no upgrades or
updates
have been ever run so far.

How can I access the database with word?



Ludwig


---------------------------(end of
broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to
majordomo@postgresql.org