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

Re: ksqo is not valid option name

From: "kj subbu" <kjsubbu(at)hotmail(dot)com>
To: daveh(at)routescape(dot)com, pgsql-odbc(at)postgresql(dot)org
Subject: Re: ksqo is not valid option name
Date: 2005-01-24 05:34:09
Message-ID: BAY17-F172DFFD605D80123F01BFDBD850@phx.gbl (view raw, whole thread or download thread mbox)
Lists: 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(at)routescape(dot)com>
>To: "kj subbu" <kjsubbu(at)hotmail(dot)com>, <pgsql-odbc(at)postgresql(dot)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.
>-----Original Message-----
>From: kj subbu [mailto:kjsubbu(at)hotmail(dot)com]
>Sent: Friday, January 21, 2005 9:22 AM
>To: pgsql-odbc(at)postgresql(dot)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
>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
>can u help me in this issue
>Thanks & Regards
>Subbiah K J
>Get head hunted by 5000 tech recruiters.
> Post your CV on
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>---------------------------(end of broadcast)---------------------------
>TIP 7: don't forget to increase your free space map settings

Connect with 1000s of singles. Receive chat 
requests. Instant message Now.

In response to

pgsql-odbc by date

Next:From: Trewern, BenDate: 2005-01-24 11:26:50
Subject: Re: Help required regarding psqlodbc driver
Previous:From: lothar.behrensDate: 2005-01-23 19:41:58
Subject: Bug in psqlodbc ?

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