Re: ksqo is not valid option name - Mailing list pgsql-odbc

HI Dave

Thanks for your mail . how to change the default odbc driver version for
connectivity .
i try to access one postgresql db with the help of odbctest with which i
create the odbc dsn name.
its connected with  errors driver is not supported . but i try to access the
same db with odbc version 2 iits connected with no errors .

how to change the default odbc driver version

pl help me in this issue

Thanks and RegardS
Subbiah K J



>From: "Dave Hartwig" <daveh@routescape.com>
>To: "kj subbu" <kjsubbu@hotmail.com>, <pgsql-odbc@postgresql.org>
>Subject: Re: [ODBC] ksqo is not valid option name Date: Fri, 21 Jan 2005
>14:28:22 -0500
>
>A long time a special optimizing strategy was devised to improve
>performance on the types of queries generated by ODBC clients.  Prior to
>key set query optimization (KSQO) the postgres optimizer would choke.
>In not so recent versions of the backend server the general optimizer
>was improved enough to deprecate KSQO.  I guess the ODBC driver has
>lagged behind.  So, at least your version still sends the SET KSQO
>command.  I believe you can turn this off somewhere in the driver
>configuration dialog.  In any case it should be harmless.
>
>David
>
>
>-----Original Message-----
>From: kj subbu [mailto:kjsubbu@hotmail.com]
>Sent: Friday, January 21, 2005 9:22 AM
>To: pgsql-odbc@postgresql.org
>Subject: [ODBC] ksqo is not valid option name
>
>Hi Postgres lovers
>                           I have serious problem  in postgresql and odbc
>.
>i have the below things in my server
>redhat linux version : 3.0 (EL)
>postgres ver :7.3.6
>unix odbc version - 2.2.8
>
>when i test the postgresql databse with isql with odbc dsn name is
>connectecd perfectly but not is not disconnectd . at the same time i got
>the
>error : ksqo is not valid option name
>
>I connect the postgresql server with the help of pgadmin is connected
>perfectly with unsupported protocol error.
>
>i dont know y the error is coming and this error on ODBC VERISON OR
>POSTGRSQL VERSION
>
>
>can u help me in this issue
>
>
>
>Thanks & Regards
>Subbiah K J
>
>_________________________________________________________________
>Get head hunted by 5000 tech recruiters.
>http://www.naukri.com/tieups/tieups.php?othersrcp=534 Post your CV on
>Naukri.com.
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>
>---------------------------(end of broadcast)---------------------------
>TIP 7: don't forget to increase your free space map settings

_________________________________________________________________
Connect with 1000s of singles.
http://www.bharatmatrimony.com/cgi-bin/bmclicks1.cgi?74 Receive chat
requests. Instant message Now.