pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedODBC-Interface (PostODBC) and Postgres 6.3.2
4+ messages / 4 participants
[nested] [flat]
* ODBC-Interface (PostODBC) and Postgres 6.3.2
@ 1998-05-14 05:39 Oliver Stegle <ostegle@fr.infra.net>
0 siblings, 2 replies; 4+ messages in thread
From: Oliver Stegle @ 1998-05-14 05:39 UTC (permalink / raw)
To: pgsql-interfaces
>Hello all together.
>
>Because of your great help, I could now set up the ODBC-Interface for
>NT(using Postgres).
>I actually forgot the "-i" -Option of the Postmaster.
>
>But there ist still one problem:
> I can import any table from the SQl-Server without problem.
> I also can use SQL-Queries out of my Programs.
>But I can't export Tables from e.g. Microsoft Access to the
>PostgreSQL-Server:
> -> ODBC-Call did not success:
> "Tha Handle does not point to a statement that is ready to be
>executed(#-1)"
>Tha Server himself writes to his logfile:
>" ERROR: msysconf: table does not exist."
>
>->it is very interesting, that the client can't write the table-content to
>the server.
> But the Table and it's fields are created successful, it's only empty.
>
>
>Have you any idea??
>
>(PS: I have compiled PSQL without readline, <- whatever readline changes??>
>
>
>Thankyou in advance and Sory for my bad english.
>
>
>Oliver
>
>
>
>
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: ODBC-Interface (PostODBC) and Postgres 6.3.2
@ 1998-05-14 12:12 Olaf Mittelstaedt <mstaedt@va-sigi.va.fh-ulm.de>
parent: Oliver Stegle <ostegle@fr.infra.net>
1 sibling, 0 replies; 4+ messages in thread
From: Olaf Mittelstaedt @ 1998-05-14 12:12 UTC (permalink / raw)
To: pgsql-interfaces
> >But I can't export Tables from e.g. Microsoft Access to the
> >PostgreSQL-Server:
> > -> ODBC-Call did not success:
> > "Tha Handle does not point to a statement that is ready to be
> >executed(#-1)"
> >Tha Server himself writes to his logfile:
> >" ERROR: msysconf: table does not exist."
You may ignore this error safely, it should work without the
MSysConf table. If you want to avoid the error message: the Access
online help desribes how to create and populate it. Look for the
keyword "MSysConf".
> >->it is very interesting, that the client can't write the table-content to
> >the server.
> > But the Table and it's fields are created successful, it's only empty
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] ODBC-Interface (PostODBC) and Postgres 6.3.2
@ 1998-05-14 13:20 Byron Nikolaidis <byronn@insightdist.com>
parent: Oliver Stegle <ostegle@fr.infra.net>
1 sibling, 0 replies; 4+ messages in thread
From: Byron Nikolaidis @ 1998-05-14 13:20 UTC (permalink / raw)
To: Oliver Stegle <ostegle@fr.infra.net>; +Cc: pgsql-interfaces
Oliver Stegle wrote:
> >But there ist still one problem:
> > I can import any table from the SQl-Server without problem.
> > I also can use SQL-Queries out of my Programs.
> >But I can't export Tables from e.g. Microsoft Access to the
> >PostgreSQL-Server:
> > -> ODBC-Call did not success:
> > "Tha Handle does not point to a statement that is ready to be
> >executed(#-1)"
> >Tha Server himself writes to his logfile:
> >" ERROR: msysconf: table does not exist."
> >
> >->it is very interesting, that the client can't write the table-content to
> >the server.
> > But the Table and it's fields are created successful, it's only empty.
> >
> >
> >Have you any idea??
Yes, the export problem ("Handle does not point to a statement that is ready..."
) IS a bug in the driver, and is fixed in version .0240, which will be released
on Friday.
The "ERROR: msysconf" is a harmless warning message actually.
Byron
^ permalink raw reply [nested|flat] 4+ messages in thread
* ODBC-Interface (PostODBC) and Postgres 6.3.2
@ 1998-05-15 03:25 The Hermit Hacker <scrappy@hub.org>
0 siblings, 0 replies; 4+ messages in thread
From: The Hermit Hacker @ 1998-05-15 03:25 UTC (permalink / raw)
To: pgsql-interfaces; +Cc: Oliver Stegle <olli2@fr.infra.net>
===================================================================
This message has been sent to a DEAD mailing list, and subsequently
reforwarded to the proper one: pgsql-interfaces@postgresql.org
===================================================================
Hello all together.
Because of your great help, I could now set up the ODBC-Interface for
NT(using Postgres).
I actually forgot the "-i" -Option of the Postmaster.
But there ist still one problem:
I can import any table from the SQl-Server without problem.
I also can use SQL-Queries out of my Programs.
But I can't export Tables from e.g. Microsoft Access to the
PostgreSQL-Server:
-> ODBC-Call did not success:
"Tha Handle does not point to a statement that is ready to be
executed(#-1)"
Tha Server himself writes to his logfile:
" ERROR: msysconf: table does not exist."
->it is very interesting, that the client can't write the table-content to
the server.
But the Table and it's fields are created successful, it's only empty.
Have you any idea??
(PS: I have compiled PSQL without readline, <- whatever readline changes??>
Thankyou in advance and Sory for my bad english.
Oliver
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~1998-05-15 03:25 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-05-14 05:39 ODBC-Interface (PostODBC) and Postgres 6.3.2 Oliver Stegle <ostegle@fr.infra.net>
1998-05-14 12:12 ` Olaf Mittelstaedt <mstaedt@va-sigi.va.fh-ulm.de>
1998-05-14 13:20 ` Byron Nikolaidis <byronn@insightdist.com>
1998-05-15 03:25 ODBC-Interface (PostODBC) and Postgres 6.3.2 The Hermit Hacker <scrappy@hub.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox