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

Re: Access97/odbcUnicode/pgsql : unable to map text field

From: "Ben Trewern" <ben(dot)trewern(at)_nospam_mowlem(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Access97/odbcUnicode/pgsql : unable to map text field
Date: 2006-06-14 13:45:38
Message-ID: e6p3tr$149o$ (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
When I know I'm going to use MS Access as a front end to a Postgresql 
database I like to keep to the following guidelines:

- Use a serial number as my primary key on each table.
- Any text fields I need to search or index use varchar(<255)
- Turn "Row Versioning" and "Text as LongVarChar" on in the dataset options. 
(I also use "Bools as Char" but I'm not sure if I need to).

Hope this helps.


"ioguix" <igxnews(at)free(dot)fr> wrote in message news:44900F9E(dot)3080402(at)free(dot)fr(dot)(dot)(dot)
> Yes, I had  problems...
> I just had an Office2k CD today and I hadn't lot of time to make tests.
> Presently, I just make a clean environnement : removed everything,
> installed the psqlodbc 8.02.02 version without Hiroshi customed dll.
> My test application work fine for text to memo mapping with the unicode
> driver, but don't work anymore about the #deleted behaviour of Access
> without vba stuffs :/
> Maybe memo type arn't used by Access to check the record ?
> I hope I will find some more time tomorrow to complete my tests.
> Postgresql and more generaly database world really miss more
> applications like Access...
> Is anyone knows an application with at least easy an form design feature ?
> Do you know some project I could join to give help (If I have the skills) 
> ?
> Does anyone would be interrested by such a project ?
> Thanks.
> -- 
> +-----------------+
> | IoGuiX          |
> | igxnews(at)free(dot)fr |
> +-----------------+
> -- Schmitter, Frdric
> Ludek Finstrle wrote:
>>>Unfortunately, I am in a mixed network with win98/win2k and winXP.
>>>I don't know if Office2000 could be installed on win98, but if not, I'll
>>>have a big problem to migrate the Access database to Postgres :s
>>>Thanks to both of you for your help, I'll try monday with Office2000
>>>and report
>>>here what's append.
>> Any progress?
>> BTW there is ANSI psqlodbc driver on Hiroshi page:
>> Luf
>>>Quoting Ludek Finstrle <luf(at)pzkagis(dot)cz>:
>>>>>But mystery is going deeper...
>>>>>I use Jet 4.0 on my winXP SP2. I followed the instructions describes in
>>>>>the last
>>>>What about MS Access 2000? Isn't problem in Access 97 itself?
>>>>BTW It seems I'll have access to computer with MS Access installed.
>>>>I have no experience with it. Could you post me your test app?
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>       choose an index scan if your joining column's datatypes do not
>       match

In response to

pgsql-odbc by date

Next:From: AndrusDate: 2006-06-14 17:27:30
Subject: Page fault on connection
Previous:From: ioguixDate: 2006-06-14 13:31:10
Subject: Re: Access97/odbcUnicode/pgsql : unable to map text field

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