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
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
Import Notes
Resolved by subject fallback
Mike Mascari wrote:
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...
I use PostgreSQL data in Word and Excel via linked tables in MS Access.
Maybe that's a solution.
Nils
On 03 May 2001 23:44:59 +0200, Nils Zonneveld wrote:
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...I use PostgreSQL data in Word and Excel via linked tables in MS Access.
Maybe that's a solution.
Can I pull data directly into Excel via JDBC?
Cheers
Tony Grant
--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html
No you can't pull directly from JDBC, but you can from ODBC
----- Original Message -----
From: "Tony Grant" <tony@animaproductions.com>
To: "Nils Zonneveld" <nils@mbit.nl>
Cc: <pgsql-general@postgresql.org>
Sent: Monday, May 07, 2001 10:33 AM
Subject: Re: [GENERAL] Re: MS-Query
Show quoted text
On 03 May 2001 23:44:59 +0200, Nils Zonneveld wrote:
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...I use PostgreSQL data in Word and Excel via linked tables in MS Access.
Maybe that's a solution.Can I pull data directly into Excel via JDBC?
Cheers
Tony Grant
--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?