"Invalid Pointer Operation" while reading tuples

From: claudia(dot)amorim(at)pcinformatica(dot)com(dot)br
To: pgsql-odbc(at)postgresql(dot)org
Subject: "Invalid Pointer Operation" while reading tuples
Date: 2007-11-27 12:09:25
Message-ID: 51882.200.178.103.132.1196165365.squirrel@smart
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hello,

I'm receiving an error message "Invalid pointer operation" when I'm reading data
from my database.
I'm using PostGreSQL 8.2.5 with Windows 2003 Server Enterprise Edition.
When I saw the psqlodbc log I found teh messages below:

[11.281]CONN ERROR: func=PGAPI_SetConnectOption, desc='', errnum=206,
errmsg='Illegal parameter value for SQL_TXN_ISOLATION'

[0.250]STATEMENT ERROR: func=set_statement_option, desc='', errnum=30,
errmsg='The option may be for MS SQL Server(Set)'

Some parts of the log:

[11.281]conn=02FB5D98, query='COMMIT'
[11.281]CONN ERROR: func=PGAPI_SetConnectOption, desc='', errnum=206,
errmsg='Illegal parameter value for SQL_TXN_ISOLATION'
[11.281] ------------------------------------------------------------
[11.281] henv=02FB2F58, conn=02FB5D98, status=1, num_stmts=16
[11.281] sock=02FA3178, stmts=02DEBD38, lobj_type=17288
[11.281] ---------------- Socket Info -------------------------------
[11.281] socket=724, reverse=0, errornumber=0, errormsg='(NULL)'
[11.281] buffer_in=48140048, buffer_out=48153296
[11.281] buffer_filled_in=18, buffer_filled_out=0, buffer_read_in=18

[0.250]conn=02DE3A70, query='close "SQL_CUR02FA8CA8"'
[0.250]conn=02DE3A70, query='RELEASE _per_query_svp_'
[0.250]conn=02DE3A70, query='close "SQL_CUR02DE85C8"'
[0.250]conn=02DE3A70, query='RELEASE _per_query_svp_'
[0.250]conn=02DE3A70, query='COMMIT'
[0.250]STATEMENT ERROR: func=set_statement_option, desc='', errnum=30,
errmsg='The option may be for MS SQL Server(Set)'
[0.250]
------------------------------------------------------------
[0.250] hdbc=02DE3A70, stmt=02DEABE8, result=00000000
[0.250] prepare=0, internal=0
[0.250] bindings=00000000, bindings_allocated=0
[0.250] parameters=00000000, parameters_allocated=0
[0.250] statement_type=-2, statement='(NULL)'
[0.250] stmt_with_params='(NULL)'
[0.250] data_at_exec=-1, current_exec_param=-1, put_data=0
[0.250] currTuple=-1, current_col=-1, lobj_fd=-1
[0.250] maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0,
scroll_concurrency=1
[0.250] cursor_name=''
[0.250] ----------------QResult Info
-------------------------------
[0.250]CONN ERROR: func=set_statement_option, desc='', errnum=0, errmsg='(NULL)'

Can you help me?

Thanks,
Cláudia.

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Luigi Pirillo 2007-11-27 15:51:54 table_to_xml command isn't working
Previous Message claudia.amorim 2007-11-25 18:01:13 Problems with PostGreSQL ODBC and Windows 2003 Server