RE: ODBC+Access2000, Win2k and Win98

From: "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk>
To: "'J(dot) 'FIK' Brand'" <jurgen(dot)brand(at)tip(dot)nl>, pgsql-odbc(at)postgresql(dot)org
Subject: RE: ODBC+Access2000, Win2k and Win98
Date: 2001-06-13 09:19:32
Message-ID: E2870D8CE1CCD311BAF50008C71EDE8E01F745E1@MAIL_EXCHANGE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hello,
Do you have Keyset Query optimization turned on in the ODBC driver?
Does the table contain a lot of data? It may be that the entire
table is trying to be loaded into the system. Try turning on the FETCH
option.
I must admit I don't tend to use dual field Primary Keys (I tend to
add in a serial field to act as a PK if the it would otherwise be multiple
columns.).
Hope you manage to get it sorted,
- Stuart

> -----Original Message-----
> From: J. 'FIK' Brand [SMTP:jurgen(dot)brand(at)tip(dot)nl]
> Sent: Friday, June 08, 2001 6:45 AM
> To: pgsql-odbc(at)postgresql(dot)org; pgsql-interfaces(at)postgresql(dot)org
> Subject: ODBC+Access2000, Win2k and Win98
>
> I've got a problem with ODBC+Access 2000 on win98, it works on win2k.
>
> In Access I link a table (c0011) when i try to open that table i get a
> error 'Out of mem'. This happens on Win98, on Win2k it works.
>
> There are more tables link and they work, but c0011 is differend because
> it is the only table where the primary key is made of 2 fields.
>
> Configuration :
>
> Server : RedHat 6.2 + Postgresql 7.1.2
>
> Client1 : Win98 se
> Postgresql ODBC 7.01.0005
> MS Office 2000 + SR1 + SR2
>
> Client2 : Win 2000 + SR1
> Postgresql ODBC 7.01.0005
> MS Office 2000 + SR1 + SR2
>
> Table c0011 :
> create table c0011 (
> al_artikelnummer varchar(12),
> al_prioriteit as int,
> al_relatienummer varchar(12),
> al_artnr_lev varchar(15),
> al_inkoopprijs as double,
> primary key (al_artikelnummer, al_prioriteit)
> )
>
>
> Jurgen Brand
> Smits Metalen Ramen

Browse pgsql-odbc by date

  From Date Subject
Next Message Mister X 2001-06-14 06:06:42 ODBC Interface version 07_01_0005, problem with C++ exceptions
Previous Message Henshall, Stuart - WCP 2001-06-13 09:11:28 RE: Image to Postgresql database