pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Evil Azrael <EvilAzrael@EvilAzrael.de>
To: pgsql-interfaces@postgresql.org
Subject: ODBC-Problem
Date: Mon, 01 Jan 2001 04:49:52 +0100
Message-ID: <3A4FFE60.972A1F1C@EvilAzrael.de> (raw)

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



view thread (27+ messages)  latest in thread

Message-ID: <3A4FFE60.972A1F1C@EvilAzrael.de>
Permalink:  ../3A4FFE60.972A1F1C@EvilAzrael.de/
Also on:    postgresql.org/message-id/3A4FFE60.972A1F1C@EvilAzrael.de

 · 

reply

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: <3A4FFE60.972A1F1C@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