Re: ODBC Driver Options

Jeff Eckermann wrote:
> --- 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.

A related question would be what the "name" of these variables are if
you are passing them in a DSN-less connection. For example, I was having
problems in my VB6 application where if I didn't turn off Keyset Query
Optimization I would get errors. This is easy to do in the ODBC setup,
but in order to do it via a DSN-less connection, you have to pass
"ksqo=;" in the connection string.

In this case, it is fairly easy to guess - but what about others, like
"use declare/fetch"? I would love to try this out in my application, but
without knowing what variable to pass - it would take a little to track
down (likely a before/after snapshot of a log, while using a DSN
connection and turning off/on the flag to see what changes in the log
entries).

A list of these variables and what their settings can be would be doubly
helpful...

Andrew Ayers
Phoenix, Arizona

>>>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/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

-- CONFIDENTIALITY NOTICE --

This message is intended for the sole use of the individual and entity to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended addressee, nor authorized to receive for the intended addressee, you are hereby notified that you may not use, copy, disclose or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email, and delete the message. Thank you.