ODBC-Problem - Mailing list pgsql-interfaces

From Evil Azrael
Subject ODBC-Problem
Date
Msg-id 3A4FFE60.972A1F1C@EvilAzrael.de
Whole thread Raw
List pgsql-interfaces
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


pgsql-interfaces by date:

Previous
From: David Wright
Date:
Subject: DBD::Pg
Next
From: Ingo Luetkebohle
Date:
Subject: Re: DBD::Pg