"Invalid Pointer Operation" while reading tuples

"Invalid Pointer Operation" while reading tuples

am 27.11.2007 13:09:25 von claudia.amorim

Hello,

I'm receiving an error message "Invalid pointer operation" when I'm readi=
ng 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=3DPGAPI_SetConnectOption, desc=3D'', errnum=3D20=
6,
errmsg=3D'Illegal parameter value for SQL_TXN_ISOLATION'


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


Some parts of the log:

[11.281]conn=3D02FB5D98, query=3D'COMMIT'
[11.281]CONN ERROR: func=3DPGAPI_SetConnectOption, desc=3D'', errnum=3D20=
6,
errmsg=3D'Illegal parameter value for SQL_TXN_ISOLATION'
[11.281] -----------------------------------------------------=
-------
[11.281] henv=3D02FB2F58, conn=3D02FB5D98, status=3D1, num_stm=
ts=3D16
[11.281] sock=3D02FA3178, stmts=3D02DEBD38, lobj_type=3D17288
[11.281] ---------------- Socket Info ------------------------=
-------
[11.281] socket=3D724, reverse=3D0, errornumber=3D0, errormsg=3D=
'(NULL)'
[11.281] buffer_in=3D48140048, buffer_out=3D48153296
[11.281] buffer_filled_in=3D18, buffer_filled_out=3D0, buffer_=
read_in=3D18





[0.250]conn=3D02DE3A70, query=3D'close "SQL_CUR02FA8CA8"'
[0.250]conn=3D02DE3A70, query=3D'RELEASE _per_query_svp_'
[0.250]conn=3D02DE3A70, query=3D'close "SQL_CUR02DE85C8"'
[0.250]conn=3D02DE3A70, query=3D'RELEASE _per_query_svp_'
[0.250]conn=3D02DE3A70, query=3D'COMMIT'
[0.250]STATEMENT ERROR: func=3Dset_statement_option, desc=3D'', errnum=3D=
30,
errmsg=3D'The option may be for MS SQL Server(Set)'
[0.250] =20
------------------------------------------------------------
[0.250] hdbc=3D02DE3A70, stmt=3D02DEABE8, result=3D000000=
00
[0.250] prepare=3D0, internal=3D0
[0.250] bindings=3D00000000, bindings_allocated=3D0
[0.250] parameters=3D00000000, parameters_allocated=3D0
[0.250] statement_type=3D-2, statement=3D'(NULL)'
[0.250] stmt_with_params=3D'(NULL)'
[0.250] data_at_exec=3D-1, current_exec_param=3D-1, put_d=
ata=3D0
[0.250] currTuple=3D-1, current_col=3D-1, lobj_fd=3D-1
[0.250] maxRows=3D0, rowset_size=3D1, keyset_size=3D0, cu=
rsor_type=3D0,
scroll_concurrency=3D1
[0.250] cursor_name=3D''
[0.250] ----------------QResult Info
-------------------------------
[0.250]CONN ERROR: func=3Dset_statement_option, desc=3D'', errnum=3D0, er=
rmsg=3D'(NULL)'



Can you help me?


Thanks,
Cl=E1udia.






---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: "Invalid Pointer Operation" while reading tuples

am 28.11.2007 15:54:47 von Hiroshi Inoue

claudia.amorim@pcinformatica.com.br wrote:
> 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'

Please try the drivers on testing for 8.2.0501 at
http://www.geocities.jp/inocchichichi/psqlodbc/index.html
..

regards,
Hiroshi Inoue

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate