pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Emils Klotins <emils@dot.lv>
To: pgsql-sql@postgresql.org
Subject: Q:Postgres 7.0 & Access'97?
Date: Tue, 13 Jun 2000 16:42:05 +0200
Message-ID: <3946645D.23400.6156CAF@localhost> (raw)

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello,

I am using Postgres 7.0 on SuSE Linux 6.2 and Postdrv.exe 
6.50.0000 (as downloaded from /latest/ dir of PG FTP site 
yesterday).

Now, I have experienced 4 issues immediately with Postgres via 
ODBC from Access and I was wondering whether you could have 
any idea what could possibly be done about them:

1. Every time a query runs from Access, I get an error on the server 
coneole:
pq_recvbuf: EOF the client closed the connection unexpectedly
The query seems to run fine though.

2. The tables on the SQL server were exported from Access tables, 
using Access' File | Export -> ODBC connection.

Now I can only access them from psql monitor if I enclose both the 
table and field names in double quotes, like "Field1". The 
tables/fields do have alphanumeric chars in them only (A-z,0-9). If I 
try to access table "Test" like: 
\d Test, I get: can't find relation 'test'.
(Note the caps both in table name & error msg)
\d "Test" works.

3. The connection seems to be QUITE slow (approximately 1-2 
seconds to show a form in Access), considering that the total of 19 
tables in the dbase contain a maximum of a couple of thousand of 
rows (I think even less). The server is a HP Netserver PIII650 and 
does not at the moment run anything else. The client computer is 
not very up-to-date, yet the same Access db with local tables runs 
practically instantly.

4. This is almost definitely an Access problem, but even if so: are 
there any workarounds available?
A WHERE clause that compares a boolean value with a boolean 
constant gives error: can't compare bool and int, use explicit cast.

Ie. in Access trying to use a SELECT .... WHERE a=True , yields 
the above error, considering that a is a boolean field.
Same query works from psql monitor.

Thanks a LOT in advance for any comments.

Emils, trying to make Access frontend work with Postgres 
backend.



-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.2 -- QDPGP 2.61a
Comment: http://community.wow.net/grt/qdpgp.html

iQA/AwUBOUYsHd0sxa1MAPWHEQKd5gCgyNG2ZXSYrfTC8w6nS3Dm4zdp7RAAn2wH
UveKFCmxHqDeGmJT1BpfyvhQ
=ZVIv
-----END PGP SIGNATURE-----



view thread (2+ messages)  latest in thread

Message-ID: <3946645D.23400.6156CAF@localhost>
Permalink:  ../3946645D.23400.6156CAF@localhost/
Also on:    postgresql.org/message-id/3946645D.23400.6156CAF@localhost

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: emils@dot.lv
  Subject: Re: Q:Postgres 7.0 & Access'97?
  In-Reply-To: <3946645D.23400.6156CAF@localhost>
  References: <3946645D.23400.6156CAF@localhost>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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