Received: from mail.grafton.lv (dns.grafton.lv [159.148.192.252]) by hub.org (8.10.1/8.10.1) with ESMTP id e5DEgET50545 for ; Tue, 13 Jun 2000 10:42:15 -0400 (EDT) Received: from mortyr (unknown [159.148.192.196]) by mail.grafton.lv (Postfix) with ESMTP id 555BE93809 for ; Tue, 13 Jun 2000 16:43:39 -0200 (GMT+2) From: "Emils Klotins" To: pgsql-sql@postgresql.org Date: Tue, 13 Jun 2000 16:42:05 +0200 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Subject: Q:Postgres 7.0 & Access'97? Message-ID: <3946645D.23400.6156CAF@localhost> X-PM-Encryptor: QDPGP, 4 X-mailer: Pegasus Mail for Win32 (v3.12c) X-Archive-Number: 200006/143 -----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-----