From: Evil Azrael <EvilAzrael@EvilAzrael.de>
To: pgsql-interfaces@postgresql.org
Subject: Re: ODBC-Problem
Date: Mon, 01 Jan 2001 14:01:03 +0100
Message-ID: <3A507F8E.E0D3D5B9@EvilAzrael.de> (raw)
References: <3A4FFE60.972A1F1C@EvilAzrael.de>
ok, i got a solution myself. i mistyped one tablename and wrote the
initial letter lower-case and it worked via odbc, even if i wroted the
name uppercase in VB. hm, that´s strange, should i post this behavior to
the bugs-mailinglist or is that behavior okay?
Christoph Nelles
Evil Azrael wrote:
>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: EvilAzrael@EvilAzrael.de
Subject: Re: ODBC-Problem
In-Reply-To: <3A507F8E.E0D3D5B9@EvilAzrael.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox