Thread: ODBC+Access2000, Win2k and Win98

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.brand@tip.nl]
> Sent:    Friday, June 08, 2001 6:45 AM
> To:    pgsql-odbc@postgresql.org; pgsql-interfaces@postgresql.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