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

Re: ODBC Driver Options

From: Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>
To: Nicola Tiling <nti(at)w4w(dot)net>, pgsql-odbc(at)postgresql(dot)org
Subject: Re: ODBC Driver Options
Date: 2004-05-17 19:09:35
Message-ID: 20040517190935.585.qmail@web20812.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-odbc
--- Dave Page <dpage(at)vale-housing(dot)co(dot)uk> wrote:
> Hi,
> 
> It's not as up to date as it should be, but most
> options are documented
> at
>
http://gborg.postgresql.org/project/psqlodbc/genpage.php?doc-config
> 
> Regards, Dave. 
> 
> > -----Original Message-----
> > From: Nicola Tiling [mailto:nti(at)w4w(dot)net] 
> > Sent: 17 May 2004 11:12
> > To: pgsql-odbc(at)postgresql(dot)org
> > Subject: [ODBC] ODBC Driver Options
> > 
> > Hi
> > 
> > I have installed psqlodbc-07_03_0200 for Windows
> (under XP). 
> > I use it for M$ Access as a frontend of a pg
> database on a 
> > FreeBSD Server.
> > 
> > Can anyone tell me where I can find any documents
> about the 
> > options of the driver? I have searched under 
> >
>
http://gborg.postgresql.org/project/psqlodbc/projdisplay.php
> 
> > and http://techdocs.postgresql.org. The document 
> >
>
"ftp://ftp.postgresql.org/pub/odbc/psqlodbc_confighelp.html"
> 
> > doesn't exist anymore.
> > 
> > I would be lucky to know what
> > 
> > - Use Declare/Fetch
> > - Parse Statements
> > - Cancel as FreeStmt(Exp)
> > - Row Versioning
> > - Disallow Premature
> > - Server side prepare
> > 
> > mean and what are the effects of them?

Since you are using MS Access, you will probably avoid
some problems by setting "row versioning" to true. 
Also, some people have reported big performance gains
from setting "use declare/fetch" to true, so you may
want to test that.  I am not aware that any of those
other options will give you any benefit with other
than default values.

> > 
> > Excuse my bad english
> > Regards
> > Nicola
> > 
> > 
> > 
> > ---------------------------(end of 
> > broadcast)---------------------------
> > TIP 9: the planner will ignore your desire to
> choose an index 
> > scan if your
> >       joining column's datatypes do not match
> > 
> 
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose
> an index scan if your
>       joining column's datatypes do not match



	
		
__________________________________
Do you Yahoo!?
SBC Yahoo! - Internet access at a great low price.
http://promo.yahoo.com/sbc/

In response to

Responses

pgsql-odbc by date

Next:From: Andrew AyersDate: 2004-05-17 19:26:51
Subject: Re: ODBC Driver Options
Previous:From: Benoit VairellesDate: 2004-05-17 15:51:04
Subject: Unicode problem with Microsoft Access

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