pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedYet another ODBC problem...
4+ messages / 3 participants
[nested] [flat]
* Yet another ODBC problem...
@ 1999-02-20 21:08 J. J. Franzen <jj@lacasabonita.com>
0 siblings, 0 replies; 4+ messages in thread
From: J. J. Franzen @ 1999-02-20 21:08 UTC (permalink / raw)
To: pgsql-interfaces
I've been hunting through the archives of this list for answers to a specific
problem... I'm trying to link tables from Access 97 to Postgres 6.4.2 and
getting a ODBC call failed error whenever I try to view the table. Now, I've
found messages discussing the problem, but I can't find any suggestions on how
to fix, or at least work around, the problem. Any suggestions would be greatly
appreciated. Thanks,
J. J. Franzen
^ permalink raw reply [nested|flat] 4+ messages in thread
* Yet Another ODBC problem...
@ 1999-02-20 21:15 J. J. Franzen <jj@lacasabonita.com>
0 siblings, 1 reply; 4+ messages in thread
From: J. J. Franzen @ 1999-02-20 21:15 UTC (permalink / raw)
To: pgsql-interfaces
I've been hunting through the archives of this list for answers to a specific
problem... I'm trying to link tables from Access 97 to Postgres 6.4.2 and
getting a ODBC call failed error whenever I try to view the table. Now, I've
found messages discussing the problem, but I can't find any suggestions on how
to fix, or at least work around, the problem. Any suggestions would be
greatly
appreciated. Thanks,
J. J. Franzen
^ permalink raw reply [nested|flat] 4+ messages in thread
* RE: [INTERFACES] Yet Another ODBC problem...
@ 1999-02-20 21:24 Michael Davis <michael.davis@prevuenet.com>
0 siblings, 0 replies; 4+ messages in thread
From: Michael Davis @ 1999-02-20 21:24 UTC (permalink / raw)
To: pgsql-interfaces
I am doing the same thing right now. I found that teaking the data types of
the tables in Postgres helps. For example:
Access data type Postgres data type
Boolean int2
>char(20) varchar
<=char(20) char
The use of varchar over char seem to help the most with errors, especially
with long character fields.
Thanks, Michael
-----Original Message-----
From: J. J. Franzen [SMTP:jj@lacasabonita.com]
Sent: Saturday, February 20, 1999 2:15 PM
To: pgsql-interfaces@postgreSQL.org
Subject: [INTERFACES] Yet Another ODBC problem...
I've been hunting through the archives of this list for answers to a
specific
problem... I'm trying to link tables from Access 97 to Postgres
6.4.2 and
getting a ODBC call failed error whenever I try to view the table.
Now, I've
found messages discussing the problem, but I can't find any
suggestions on how
to fix, or at least work around, the problem. Any suggestions would
be
greatly
appreciated. Thanks,
J. J. Franzen
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] Yet Another ODBC problem...
@ 1999-02-22 14:39 Byron Nikolaidis <byronn@insightdist.com>
parent: J. J. Franzen <jj@lacasabonita.com>
0 siblings, 0 replies; 4+ messages in thread
From: Byron Nikolaidis @ 1999-02-22 14:39 UTC (permalink / raw)
To: J. J. Franzen <jj@lacasabonita.com>; +Cc: pgsql-interfaces
J. J. Franzen wrote:
> I've been hunting through the archives of this list for answers to a specific
> problem... I'm trying to link tables from Access 97 to Postgres 6.4.2 and
> getting a ODBC call failed error whenever I try to view the table. Now, I've
> found messages discussing the problem, but I can't find any suggestions on how
> to fix, or at least work around, the problem. Any suggestions would be
> greatly
> appreciated. Thanks,
>
Check the "c:\psqlodbc.log" file for any errors. You may have to enable the
Commlog option under driver options. You can attach a copy of the log file if you
want me to take a look at it.
Byron
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~1999-02-22 14:39 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-02-20 21:08 Yet another ODBC problem... J. J. Franzen <jj@lacasabonita.com>
1999-02-20 21:15 Yet Another ODBC problem... J. J. Franzen <jj@lacasabonita.com>
1999-02-22 14:39 ` Re: [INTERFACES] Yet Another ODBC problem... Byron Nikolaidis <byronn@insightdist.com>
1999-02-20 21:24 RE: [INTERFACES] Yet Another ODBC problem... Michael Davis <michael.davis@prevuenet.com>
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