Received: from SRV.CTLNO.COM ([204.252.218.112]) by hub.org (8.8.8/8.7.5) with ESMTP id DAA05259 for ; Sun, 14 Jun 1998 03:36:19 -0400 (EDT) Received: by srv.ctlno.com with Internet Mail Service (5.0.1457.3) id ; Sun, 14 Jun 1998 02:36:05 -0500 Message-ID: From: Matthew To: "'pgsql-interfaces@postgreSQL.org'" Subject: MS Access can't insert with ODBC connection to PostgreSQL Date: Sun, 14 Jun 1998 02:35:57 -0500 X-Priority: 3 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.0.1457.3) Content-Type: text/plain Hello, I downloaded the latest ODBC driver for PostgreSQL from http://www.insightdist.com/psqlodbc/ version number 06.30.0245. I got this driver to work and show data from my database after editing the pg_hba.conf file. However, I can't insert new records in the normal access way. I can do these inserts when I connect to MS SQL server with an ODBC driver in the same manner as above. Is this typical? Or do I have something configured wrong? I unchecked both readonly checkboxes in the ODBC config, but that had no effect. I was able to do a manual insert query by hardcoding it. Please help, Thanks much, Matt O'Connor