Thread: MS-Query

MS-Query

From
Ludwig Meyerhoff
Date:
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


RE: MS-Query

From
Mike Mascari
Date:
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

Re: MS-Query

From
Nils Zonneveld
Date:

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

Re: Re: MS-Query

From
Tony Grant
Date:
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


Re: Re: MS-Query

From
"Dave Cramer"
Date:
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
>
>