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

Access -> ODBC -> postgres

From: Eliott <eliott100(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Access -> ODBC -> postgres
Date: 2006-04-21 13:22:37
Message-ID: c2162c750604210622x15d66899n583adaff7cf24f07@mail.gmail.com (view raw or flat)
Thread:
Lists: 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

Responses

pgsql-odbc by date

Next:From: Ludek FinstrleDate: 2006-04-21 13:28:15
Subject: Re: Access -> ODBC -> postgres
Previous:From: Thomas ChabaudDate: 2006-04-20 06:50:32
Subject: Re: Max LongVarChar

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