Thread: ODBC+Access2000, Win2k and Win98

ODBC+Access2000, Win2k and Win98

From
"J. 'FIK' Brand"
Date:
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

RE: ODBC+Access2000, Win2k and Win98

From
"Henshall, Stuart - WCP"
Date:
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