Access -> ODBC -> postgres - Mailing list pgsql-odbc

From Eliott
Subject Access -> ODBC -> postgres
Date
Msg-id c2162c750604210622x15d66899n583adaff7cf24f07@mail.gmail.com
Whole thread Raw
Responses Re: Access -> ODBC -> postgres  (Ludek Finstrle <luf@pzkagis.cz>)
List pgsql-odbc
Hi!

I am trying to create a front-end to an existing postgres database in MS Access 2002 using 8.01.20 Unicode ODBC driver. Some of the simpler queries were working, but as soon as I try to use a dynamic parameter, the query sent to the server gets syntactically incorrect. I have attached some logs to make it clear:
                           hdbc=151272720, stmt=151283976, result=151266488
                 manual_result=1, prepare=0, internal=0
                 bindings=0, bindings_allocated=0
                 parameters=151288880, parameters_allocated=1
                 statement_type=0, statement='SELECT "public"."organization_user"."id","public"."bidding_auction"."id","public"."organization_company"."id" FROM "public"."bidding_auction","public"."organization_user","public"."organization_company" WHERE (("public"."organization_user"."id" = "public"."bidding_auction"."organizer_id" ) AND (("public"."organization_user"."company_id" = "public"."organization_company"."id" ) AND ("public"."organization_company"."id" =  ? ) ) ) '
                 stmt_with_params='SELECT "public"."organization_user"."id","public"."bidding_auction"."id","public"."organization_company"."id" FROM "public"."bidding_auction","public"."organization_user","public"."organization_company" WHERE (("public"."organization_user"."id" = "public"."bidding_auction"."organizer_id" ) AND (("public"."organization_user"."company_id" = "public"."organization_company"."id" ) AND ("public"."organization_company"."id" =  38'
                 data_at_exec=-1, current_exec_param=-1, put_data=0
                 currTuple=-1, current_col=-1, lobj_fd=-1
                 maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1
                 cursor_name='SQL_CUR09046908'
                 ----------------QResult Info -------------------------------
                 fields=151266624, manual_tuples=0, backend_tuples=0, tupleField=0, conn=0
                 fetch_count=0, num_total_rows=0, num_fields=0, cursor='(NULL)'
                 message='(NULL)', command='(NULL)', notice='(NULL)'
                 status=7, inTuples=0
CONN ERROR: func=SC_execute, desc='', errnum=108, sqlstate=42601, errmsg='ERROR:  syntax error at end of input at character 396'

My settings are as follows: Disable generic optimizer on, KSQO, Parse statements on (I experimented with toggling these with no difference)

As you can see, the stmt_with_params is missing  three ')'-s from the end. Can anybody tell me what causes this behaviour and how can I get rid of it?

Regards
Eliott

pgsql-odbc by date:

Previous
From: Thomas Chabaud
Date:
Subject: Re: Max LongVarChar
Next
From: Ludek Finstrle
Date:
Subject: Re: Access -> ODBC -> postgres