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

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 (view raw or flat)
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

pgsql-odbc by date

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

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