Hosting Provided By

[GENERAL] "Invalid Pointer Operation" while reading tuples

From: <claudia.amorim(at)pcinformatica.com.br>
Date: Tue Nov 27 2007 - 07:13:01 EST

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?

Do you need help?

Thanks,
Cláudia.

---------------------------(end of broadcast)---------------------------

TIP 4: Have you searched our list archives?

http://archives.postgresql.org/ Received on Tue Nov 27 07:15:35 2007

This message: [ Message body ]
Next message: Thomas Chille: "Re: [GENERAL] autovacuum process blocks without reporting a deadlock"
Previous message: Zoltan Boszormenyi: "Re: [GENERAL] select using an index"

Contemporary messages sorted: [ By Date ] [ By Thread ] [ By Subject ] [ By Author ] [ By messages with attachments ]

This archive was generated by hypermail 2.1.8 : Mon Jun 16 2008 - 20:37:19 EDT