Обсуждение: 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
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 > 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? > > http://www.postgresql.org/users-lounge/docs/faq.html > >