-----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-----