Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f02MO6706964 for ; Tue, 2 Jan 2001 17:24:06 -0500 (EST) (envelope-from pgsql-interfaces-owner@postgresql.org) Received: from hermes.altec.group (hermes.altecgroup.gr [212.89.165.3]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f01B3OL59491 for ; Mon, 1 Jan 2001 06:03:29 -0500 (EST) (envelope-from EvilAzrael@EvilAzrael.de) Received: from cyclades.acn.gr ([172.16.10.103]) by hermes.altec.group (Netscape Messaging Server 4.15) with SMTP id G6HDD600.P01 for ; Mon, 1 Jan 2001 13:03:06 +0200 Received: from router.azrael.de ([62.225.229.111]) by cyclades.acn.gr (NAVIEG 2.1 bld 63) with SMTP id M2001010113030427118 ; Mon, 01 Jan 2001 13:03:04 +0200 Received: from EvilAzrael.de (azrael.azrael.de [192.168.202.18]) by router.azrael.de (8.10.2/8.10.2) with ESMTP id f013jlH01047 for ; Mon, 1 Jan 2001 04:45:47 +0100 Message-ID: <3A4FFE60.972A1F1C@EvilAzrael.de> Date: Mon, 01 Jan 2001 04:49:52 +0100 From: Evil Azrael Organization: No Organization - Just Chaos X-Mailer: Mozilla 4.76 [en] (WinNT; U) X-Accept-Language: de,en MIME-Version: 1.0 To: pgsql-interfaces@postgresql.org Subject: ODBC-Problem Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Archive-Number: 200101/17 X-Sequence-Number: 626 HI I have just moved my old MS Access Database to a postgres database via odbc. all went okay, and i can access the database in MS Access via ODBC. Only a Client programm that i wrote canīt access the database anymore via ODBC. The Visual BAsic Database programm says that the database itself is updateable, but the tables in it arenīt updateable, and all tries to connect to a table in VB via the OpenRecordset method fail with the error message "parse error near [name of the table]" or VB tells that itīs a connection error. Thatīs weird. MS Access has no problems connecting and writing to the database. VBīs Visual Database Manager can connect to the database, but can only read tables. MY VB programm canīt even connect to the tables, but it worked quite good via ODBC to the Access Database. I donīt know what i can anymore, so please help if you know a solution. Christoph Nelles