pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedODBC Problem - Please help
2+ messages / 2 participants
[nested] [flat]
* ODBC Problem - Please help
@ 1999-10-15 00:53 Lakshmi Anand K. <lakshmianand@vsnl.com>
1999-10-18 02:01 ` Re: [INTERFACES] ODBC Problem - Please help Byron Nikolaidis <byron.nikolaidis@home.com>
0 siblings, 1 reply; 2+ messages in thread
From: Lakshmi Anand K. @ 1999-10-15 00:53 UTC (permalink / raw)
To: pgsql-interfaces
Err . . . Am new to postgres and this list. I am using the ODBC Driver from
Insight Corp Version 6.40.00.04 and Postgres Version 6.5.1-2. I am having
Win 98 clients and want to access Postgres via ODBC. Now, am able to access
it with psql from the server. When I try to use it from Access, VFP, VB it
creates problems.
Access 2000: It simply says cannot open the table in datasheet view.
VB: Am able to access as dynaset or snapshot but when I try to use
SQLPassthru, then I get error messages that the call failed.
VFP: Am able to access properly but get error messages often.
It seems as if garbage statements with parse errors are sent to the backend.
I have attached a sample log file. Please help.
*-*-*
Lakshmi Anand K.
Attachments:
psqlodbc_4294639205.log (application/octet-stream, 14.5K) download
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [INTERFACES] ODBC Problem - Please help
1999-10-15 00:53 ODBC Problem - Please help Lakshmi Anand K. <lakshmianand@vsnl.com>
@ 1999-10-18 02:01 ` Byron Nikolaidis <byron.nikolaidis@home.com>
0 siblings, 0 replies; 2+ messages in thread
From: Byron Nikolaidis @ 1999-10-18 02:01 UTC (permalink / raw)
To: Lakshmi Anand K. <lakshmianand@vsnl.com>; +Cc: pgsql-interfaces
"Lakshmi Anand K." wrote:
>
> Err . . . Am new to postgres and this list. I am using the ODBC Driver from
> Insight Corp Version 6.40.00.04 and Postgres Version 6.5.1-2. I am having
> Win 98 clients and want to access Postgres via ODBC. Now, am able to access
> it with psql from the server. When I try to use it from Access, VFP, VB it
> creates problems.
>
> Access 2000: It simply says cannot open the table in datasheet view.
> VB: Am able to access as dynaset or snapshot but when I try to use
> SQLPassthru, then I get error messages that the call failed.
> VFP: Am able to access properly but get error messages often.
>
> It seems as if garbage statements with parse errors are sent to the backend.
> I have attached a sample log file. Please help.
>
> *-*-*
> Lakshmi Anand K.
>
> ------------------------------------------------------------------------
> Name: psqlodbc_4294639205.log
> psqlodbc_4294639205.log Type: LOG File (application/x-unknown-content-type-log_auto_file)
> Encoding: quoted-printable
You can ignore the errors about the msysconf table not existing. This
is an optional Jet database configuration file. It is ok if it does not
exist.
The other errors are a query that simply consists of "godisgreat". Is
this perhaps a table? Some databases may accept this as a valid query
( equal to select * from godisgreat ) but I don't think Postgres does?
Byron
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1999-10-18 02:01 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-10-15 00:53 ODBC Problem - Please help Lakshmi Anand K. <lakshmianand@vsnl.com>
1999-10-18 02:01 ` Byron Nikolaidis <byron.nikolaidis@home.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