Re: ERROR - no error information available

Luf,

I apologize for not being clear the first time. Below is a snippet from my
log that I think maybe the suspect. The SELECT statement below is one (of
many) from the code that is dying. I have attached my whole mylog file too.

As far as a scenario goes, I have a data adapter that is responsible for
handling the querying of the database and some queries are executing fine,
other are not (e.g. like the one below). The queries work fine against other
databases. To troubleshoot, I have copied the offending statements out of
the code to a sql editor to verify the queries; they are fine and do what
they are supposed to. I keep getting a Windows crash dialog box (the one
that asks if you would like to send a report to Microsoft) and it shows the
psqlodbc.dll as the offending module. The message displayed when you click
the, "Click Here" link after the text, "To see what data this error report
contains" is:

Error Signature
-------------------
AppName: ctia.icts.dcp_main.exe AppVer: 1.0.2166.29176 ModName:
psqlodbc.dll
ModVer: 8.0.1.1 Offset: 0001ffef

Hope this level of detail is enough. If not let me know.

Thanks!
dw

mylog snippet
-----------------------

[5564][SQLGetDiagRecW][5564]PGAPI_GetDiagRec entering rec=1[5564]****
PGAPI_ConnectError: hdbc=134127624 <0>
[5564]enter CC_get_error
[5564]enter CC_create_errormsg
[5564]msg = 'The buffer was too small for the ConnStrOut.'
[5564]exit CC_create_errormsg
[5564]exit CC_get_error
[5564]CC_get_error: status = 215, msg = #The buffer was too small for the
ConnStrOut.#
[5564] szSqlState = '01004',len=44, szError='(null)'
[5564]PGAPI_GetDiagRec exiting 1
[5564][SQLGetDiagRecW][5564]PGAPI_GetDiagRec entering rec=1[5564]****
PGAPI_ConnectError: hdbc=134127624 <46>
[5564]enter CC_get_error
[5564]exit CC_get_error
[5564]CC_get_error: status = 215, msg = #The buffer was too small for the
ConnStrOut.#
[5564] szSqlState = '(null)',len=44, szError='The buffer was too small
for the ConnStrOut.'
[5564]PGAPI_GetDiagRec exiting 0
[5564][[SQLGetDiagFieldW]] Handle=(2,7fea008) Rec=1 Id=8
[5564]PGAPI_GetDiagField entering rec=1[5564]PGAPI_GetDiagField exiting 0
[5564][[SQLGetDiagFieldW]] Handle=(2,7fea008) Rec=1 Id=9
[5564]PGAPI_GetDiagField entering rec=1[5564]PGAPI_GetDiagField exiting 0
[5564][[SQLGetDiagFieldW]] Handle=(2,7fea008) Rec=1 Id=10
[5564]PGAPI_GetDiagField entering rec=1[5564]PGAPI_GetDiagField exiting 0
[5564][[SQLGetDiagFieldW]] Handle=(2,7fea008) Rec=1 Id=11
[5564]PGAPI_GetDiagField entering rec=1[5564]PGAPI_GetDiagField exiting 0
[5564][SQLGetDiagRecW][5564]PGAPI_GetDiagRec entering rec=2[5564]****
PGAPI_ConnectError: hdbc=134127624 <0>
[5564]PGAPI_GetDiagRec exiting 100
[5564][SQLGetFunctions][5564][SQLGetInfoW(30)][5564]PGAPI_GetInfo:
entering...fInfoType=23
[5564]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=2
[5564][SQLGetInfoW(30)][5564]PGAPI_GetInfo: entering...fInfoType=24
[5564]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=2
[5564][SQLGetInfoW(30)][5564]PGAPI_GetInfo: entering...fInfoType=1750
[5564]CONN ERROR: func=PGAPI_GetInfo30, desc='', errnum=209,
errmsg='Unrecognized key passed to SQLGetInfo30.'
[5564]CONN ERROR: func=SQLGetInfoW(30), desc='', errnum=209,
errmsg='Unrecognized key passed to SQLGetInfo30.'
[5564][SQLGetConnectAttrW][5564]PGAPI_GetConnectAttr 1209
[5564][[SQLAllocHandle]][5564]PGAPI_AllocStmt: entering...
[5564]**** PGAPI_AllocStmt: hdbc = 134127624, stmt = 99068032
[5564]CC_add_statement: self=134127624, stmt=99068032
[5564][SQLGetStmtAttrW][5564]PGAPI_GetStmtAttr Handle=99068032 10010
[5564][SQLGetStmtAttrW][5564]PGAPI_GetStmtAttr Handle=99068032 10011
[5564][SQLGetStmtAttrW][5564]PGAPI_GetStmtAttr Handle=99068032 10012
[5564][SQLGetStmtAttrW][5564]PGAPI_GetStmtAttr Handle=99068032 10013
[5564][SQLSetStmtAttrW][5564]PGAPI_SetStmtAttr Handle=99068032 0,30
[5564]PGAPI_SetStmtOption: entering...
[5564]SetStmtOption: SQL_QUERY_TIMEOUT, vParam = 30
[5564][SQLGetConnectAttrW][5564]PGAPI_GetConnectAttr 1209
[5564][SQLSetStmtAttrW][5564]PGAPI_SetStmtAttr Handle=99068032 1228,0
[5564]PGAPI_SetStmtOption: entering...
[5564][SQLSetStmtAttrW][5564]PGAPI_SetStmtAttr Handle=99068032 1227,0
[5564]PGAPI_SetStmtOption: entering...
[5564][SQLExecDirectW][5564]PGAPI_ExecDirect: entering...
[5564]recycle statement: self= 99068032
[5564]PDATA_free_params: ENTER, self=99068456
[5564]**** PGAPI_ExecDirect: hstmt=99068032, statement='SELECT DISTINCT
nominal_value FROM doctrine WHERE (nominal_value IS NOT NULL)'
[5564]PGAPI_ExecDirect: calling PGAPI_Execute...
[5564]PGAPI_Execute: entering...
[5564]PGAPI_Execute: clear errors...
[5564]recycle statement: self= 99068032
[5564]PDATA_free_params: ENTER, self=99068456
[5564]Exec_with_parameters_resolved: copying statement params:
trans_status=1, len=77, stmt='SELECT DISTINCT nominal_value FROM doctrine
WHERE (nominal_value IS NOT NULL)'
[5564] stmt_with_params = 'SELECT DISTINCT nominal_value FROM doctrine
WHERE (nominal_value IS NOT NULL)'
[5564] Sending SELECT statement on stmt=99068032,
cursor_name='SQL_CUR05E7A880'
[5564]send_query(): conn=134127624, query='SELECT DISTINCT nominal_value
FROM doctrine WHERE (nominal_value IS NOT NULL)'
[5564]send_query: done sending query
[5564]in QR_Constructor
[5564]exit QR_Constructor
[5564]read 49, global_socket_buffersize=8192
[5564]send_query: got id = 'P'
[5564]send_query: got id = 'T'
[5564]QR_fetch_tuples: cursor = '', self->cursor=0
[5564]num_fields = 1
[5564]READING ATTTYPMOD
[5564]CI_read_fields: fieldname='nominal_value', adtid=1043, adtsize=-1,
atttypmod=45
[5564]QR_fetch_tuples: past CI_read_fields: num_fields = 1
[5564]MALLOC: tuple_size = 100, size = 800
[5564]next_tuple: inTuples = true, falling through: fcount = 101,
fetch_count = 101
[5564]qresult: len=0, buffer=''
[5564]end of tuple list -- setting inUse to false: this = 99067856
[5564]_next_tuple: 'C' fetch_total = 1 & this_fetch = 1
[5564]send_query: got id = 'Z'
[5564] done sending the query:
[5564]extend_column_bindings: entering ... self=99068168,
bindings_allocated=0, num_columns=1
[5564]exit extend_column_bindings
[5564]PGAPI_ExecDirect: returned 0 from PGAPI_Execute
[5564][SQLNumResultCols][5564]PGAPI_NumResultCols: entering...
[5564]SC_pre_execute: status = 3
[5564]PGAPI_NumResultCols: result = 99067856, status = 3, numcols = 1
[5564][SQLGetConnectAttrW][5564]PGAPI_GetConnectAttr 1209
[5564][SQLColAttributeW][5564]PGAPI_ColAttributes: entering..col=1 1011
len=6144.
[5564]SC_pre_execute: status = 3
[5564]**** PGAPI_ColAtt: result = 99067856, status = 3, numcols = 1
[5564]colAttr: col 0 field_type = 1043
[5564]PGAPI_ColAttr: COLUMN_NAME = 'nominal_value'
[5564][SQLGetConnectAttrW][5564]PGAPI_GetConnectAttr 1209
[5564][SQLColAttributeW][5564]PGAPI_ColAttributes: entering..col=1 2
len=4096.
[5564]SC_pre_execute: status = 3
[5564]**** PGAPI_ColAtt: result = 99067856, status = 3, numcols = 1
[5564]colAttr: col 0 field_type = 1043
[5564]getCharColumnSize: type=1043, col=0, unknown = 0
[5564]COLUMN_TYPE=-9
[5564][[SQLFetch]][5564]PGAPI_ExtendedFetch: stmt=99068032

-----Original Message-----
From: pgsql-odbc-owner(at)postgresql(dot)org
[mailto:pgsql-odbc-owner(at)postgresql(dot)org]On Behalf Of Ludek Finstrle
Sent: Tuesday, December 06, 2005 5:33 PM
To: DWilkerson
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] ERROR - no error information available

> I am receiving the error, "ERROR - no error information available", in my

When you got the error? I can't reproduce your error here with informations
you posted.

> I was using the 8000101 version of the pgsql odbc driver and I tried
> downloading a newer version (8010102). This didn't help...actually made it
> worse.

What do you mean with "made it worse"? I'm sorry but we aren't crystal
gazers.

It's good idea to post mylog output at least. Or complete minimalistic
example with problem (data and program - source or executable).

Regards,

Luf

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster