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

"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 (view raw or flat)
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

pgsql-odbc by date

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

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