Skip site navigation (1) Skip section navigation (2)

Re: Strange ODBC behavior.

From: Paul Lambert <paul(dot)lambert(at)autoledgers(dot)com(dot)au>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Strange ODBC behavior.
Date: 2007-08-05 22:26:09
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
Andrei Kovalevski wrote:

>> Any thoughts on this or is it more of an access issue?
> 1) Could you post here CREATE script for one of the tables with problem 
> you descrived?  #delete message appears when something happens to the 
> primary keys.
> 2) What is the version of your MS Access? PostgreSQL? Unicode or ANSI 
> driver version?
> 3) Please, have a look on the linked table structure as it's recognised 
> by MS Access. And post it here.
> Andrei.

I believe I have found the problem.

The primary key fields are defined in PG as type text, but MS access is 
bringing them across as type "memo" - whatever that is.

It seems to be bringing most text type fields across like this.

I changed them to varchar on one of the tables I'm having a problem 
with, relinked and they are coming across with a type of text on the 
fields now and I can see the data without issue.

Strange... has anyone see that before?

Paul Lambert
Database Administrator

In response to


pgsql-odbc by date

Next:From: Adrian KlaverDate: 2007-08-05 23:41:18
Subject: Re: Strange ODBC behavior.
Previous:From: Adrian KlaverDate: 2007-08-03 14:21:36
Subject: Re: Strange ODBC behavior.

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group