hi, here are the two sql logs for the same code when one is run independently
and when embedded in the other when it is embedded in the other it hangs and
the application crashes so could any one tell what the problem can be..it
crashes for the reason
0x4054afde in my_SQLPrepare () from /usr/local/lib/libmyodbc3-3.51.06.so
so i think my_SQLPrepare() method fails somehow so can anyone help me, thanks
in advance.
===========================
When run with in an application
===========================
[ODBC][4507][__handles.c][368]
Exit:[SQL_SUCCESS]
Environment = 0x8664fb8
[ODBC][4507][SQLSetEnvAttr.c][154]
Entry:
Environment = 0x8664fb8
Attribute = SQL_ATTR_ODBC_VERSION
Value = 0x3
StrLen = (nil)
[ODBC][4507][SQLSetEnvAttr.c][315]
Exit:[SQL_SUCCESS]
[ODBC][4507][SQLAllocHandle.c][315]
Entry:
Handle Type = 2
Input Handle = 0x8664fb8
[ODBC][4507][SQLAllocHandle.c][429]
Exit:[SQL_SUCCESS]
Output Handle = 0x8665548
[ODBC][4507][SQLSetConnectAttr.c][267]
Entry:
Connection = 0x8665548
Attribute = SQL_ATTR_LOGIN_TIMEOUT
Value = 0x5
StrLen = (nil)
[ODBC][4507][SQLSetConnectAttr.c][453]
Exit:[SQL_SUCCESS]
[ODBC][4507][SQLConnect.c][2390]
Entry:
Connection = 0x8665548
Server Name = [TelePro][length = 7 (SQL_NTS)]
User Name = [ippbx][length = 5 (SQL_NTS)]
Authentication = [*****][length = 5 (SQL_NTS)]
[ODBC][4507][SQLConnect.c][2947]
Exit:[SQL_SUCCESS]
[ODBC][4507][SQLAllocHandle.c][476]
Entry:
Handle Type = 3
Input Handle = 0x8665548
[ODBC][4507][SQLAllocHandle.c][840]
Exit:[SQL_SUCCESS]
Output Handle = 0x866cbd8
[ODBC][4507][SQLExecDirect.c][200]
Entry:
Statement = 0x866cbd8
SQL = [select extension from SUBSCRIBER where
subscriber_type = 0][length =
58 (SQL_NTS)]
===========================
when run independently
===========================
[ODBC][4509][__handles.c][368]
Exit:[SQL_SUCCESS]
Environment = 0x805e2b8
[ODBC][4509][SQLSetEnvAttr.c][154]
Entry:
Environment = 0x805e2b8
Attribute = SQL_ATTR_ODBC_VERSION
Value = 0x3
StrLen = (nil)
[ODBC][4509][SQLSetEnvAttr.c][315]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLAllocHandle.c][315]
Entry:
Handle Type = 2
Input Handle = 0x805e2b8
[ODBC][4509][SQLAllocHandle.c][429]
Exit:[SQL_SUCCESS]
Output Handle = 0x805e9b0
[ODBC][4509][SQLSetConnectAttr.c][267]
Entry:
Connection = 0x805e9b0
Attribute = SQL_ATTR_LOGIN_TIMEOUT
Value = 0x5
StrLen = (nil)
[ODBC][4509][SQLSetConnectAttr.c][453]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLConnect.c][2390]
Entry:
Connection = 0x805e9b0
Server Name = [TelePro][length = 7 (SQL_NTS)]
User Name = [ippbx][length = 5 (SQL_NTS)]
Authentication = [*****][length = 5 (SQL_NTS)]
[ODBC][4509][SQLConnect.c][2947]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLAllocHandle.c][476]
Entry:
Handle Type = 3
Input Handle = 0x805e9b0
[ODBC][4509][SQLAllocHandle.c][840]
Exit:[SQL_SUCCESS]
Output Handle = 0x8066d10
[ODBC][4509][SQLExecDirect.c][200]
Entry:
Statement = 0x8066d10
SQL = [select extension from SUBSCRIBER where
subscriber_type = 0][length =
58 (SQL_NTS)]
[ODBC][4509][SQLExecDirect.c][425]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLBindCol.c][154]
Entry:
Statement = 0x8066d10
Column Number = 1
Target Type = -16 SQL_C_SLONG
Target Value = 0xbfffedec
Buffer Length = 100
StrLen Or Ind = 0xbffff1f4
[ODBC][4509][SQLBindCol.c][244]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLFetch.c][146]
Entry:
Statement = 0x8066d10
[ODBC][4509][SQLFetch.c][338]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLFetch.c][146]
Entry:
Statement = 0x8066d10
[ODBC][4509][SQLFetch.c][338]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLFetch.c][146]
Entry:
Statement = 0x8066d10
[ODBC][4509][SQLFetch.c][338]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLFetch.c][146]
Entry:
Statement = 0x8066d10
[ODBC][4509][SQLFetch.c][338]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLFetch.c][146]
Entry:
Statement = 0x8066d10
[ODBC][4509][SQLFetch.c][338]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLFetch.c][146]
Entry:
Statement = 0x8066d10
[ODBC][4509][SQLFetch.c][338]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLFetch.c][146]
Entry:
Statement = 0x8066d10
[ODBC][4509][SQLFetch.c][338]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLFetch.c][146]
Entry:
Statement = 0x8066d10
[ODBC][4509][SQLFetch.c][338]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLFetch.c][146]
Entry:
Statement = 0x8066d10
[ODBC][4509][SQLFetch.c][338]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLFetch.c][146]
Entry:
Statement = 0x8066d10
[ODBC][4509][SQLFetch.c][338]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLFetch.c][146]
Entry:
Statement = 0x8066d10
[ODBC][4509][SQLFetch.c][338]
Exit:[SQL_NO_DATA]
[ODBC][4509][SQLFreeHandle.c][349]
Entry:
Handle Type = 3
Input Handle = 0x8066d10
[ODBC][4509][SQLFreeHandle.c][450]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLAllocHandle.c][476]
Entry:
Handle Type = 3
Input Handle = 0x805e9b0
[ODBC][4509][SQLAllocHandle.c][840]
Exit:[SQL_SUCCESS]
Output Handle = 0x80673a8
[ODBC][4509][SQLExecDirect.c][200]
Entry:
Statement = 0x80673a8
SQL = [SELECT STATION.description from STATION,
SUBSSTAT, SUBSCRIBER
where SUBSCRIBER.extension=101 and
(SUBSCRIBER.id=SUBSSTA...][length =
185 (SQL_NTS)]
[ODBC][4509][SQLExecDirect.c][425]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLBindCol.c][154]
Entry:
Statement = 0x80673a8
Column Number = 1
Target Type = 1 SQL_CHAR
Target Value = 0xbfffe930
Buffer Length = 80
StrLen Or Ind = 0xbfffed88
[ODBC][4509][SQLBindCol.c][244]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLFetch.c][146]
Entry:
Statement = 0x80673a8
[ODBC][4509][SQLFetch.c][338]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLFreeHandle.c][349]
Entry:
Handle Type = 3
Input Handle = 0x80673a8
[ODBC][4509][SQLFreeHandle.c][450]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLAllocHandle.c][476]
Entry:
Handle Type = 3
Input Handle = 0x805e9b0
[ODBC][4509][SQLAllocHandle.c][840]
Exit:[SQL_SUCCESS]
Output Handle = 0x80673a8
[ODBC][4509][SQLExecDirect.c][200]
Entry:
Statement = 0x80673a8
SQL = [SELECT STATION.description from STATION,
SUBSSTAT, SUBSCRIBER
where SUBSCRIBER.extension=102 and
(SUBSCRIBER.id=SUBSSTA...][length =
185 (SQL_NTS)]
[ODBC][4509][SQLExecDirect.c][425]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLBindCol.c][154]
Entry:
Statement = 0x80673a8
Column Number = 1
Target Type = 1 SQL_CHAR
Target Value = 0xbfffe930
Buffer Length = 80
StrLen Or Ind = 0xbfffed88
[ODBC][4509][SQLBindCol.c][244]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLFetch.c][146]
Entry:
Statement = 0x80673a8
[ODBC][4509][SQLFetch.c][338]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLFreeHandle.c][349]
Entry:
Handle Type = 3
Input Handle = 0x80673a8
[ODBC][4509][SQLFreeHandle.c][450]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLAllocHandle.c][476]
Entry:
Handle Type = 3
Input Handle = 0x805e9b0
[ODBC][4509][SQLAllocHandle.c][840]
Exit:[SQL_SUCCESS]
Output Handle = 0x80673a8
[ODBC][4509][SQLExecDirect.c][200]
Entry:
Statement = 0x80673a8
SQL = [SELECT STATION.description from STATION,
SUBSSTAT, SUBSCRIBER
where SUBSCRIBER.extension=103 and
(SUBSCRIBER.id=SUBSSTA...][length =
185 (SQL_NTS)]
[ODBC][4509][SQLExecDirect.c][425]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLBindCol.c][154]
Entry:
Statement = 0x80673a8
Column Number = 1
Target Type = 1 SQL_CHAR
Target Value = 0xbfffe930
Buffer Length = 80
StrLen Or Ind = 0xbfffed88
[ODBC][4509][SQLBindCol.c][244]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLFetch.c][146]
Entry:
Statement = 0x80673a8
[ODBC][4509][SQLFetch.c][338]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLFreeHandle.c][349]
Entry:
Handle Type = 3
Input Handle = 0x80673a8
[ODBC][4509][SQLFreeHandle.c][450]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLAllocHandle.c][476]
Entry:
Handle Type = 3
Input Handle = 0x805e9b0
[ODBC][4509][SQLAllocHandle.c][840]
Exit:[SQL_SUCCESS]
Output Handle = 0x80673a8
[ODBC][4509][SQLExecDirect.c][200]
Entry:
Statement = 0x80673a8
SQL = [SELECT STATION.description from STATION,
SUBSSTAT, SUBSCRIBER
where SUBSCRIBER.extension=104 and
(SUBSCRIBER.id=SUBSSTA...][length =
185 (SQL_NTS)]
[ODBC][4509][SQLExecDirect.c][425]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLBindCol.c][154]
Entry:
Statement = 0x80673a8
Column Number = 1
Target Type = 1 SQL_CHAR
Target Value = 0xbfffe930
Buffer Length = 80
StrLen Or Ind = 0xbfffed88
[ODBC][4509][SQLBindCol.c][244]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLFetch.c][146]
Entry:
Statement = 0x80673a8
[ODBC][4509][SQLFetch.c][338]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLFreeHandle.c][349]
Entry:
Handle Type = 3
Input Handle = 0x80673a8
[ODBC][4509][SQLFreeHandle.c][450]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLAllocHandle.c][476]
Entry:
Handle Type = 3
Input Handle = 0x805e9b0
[ODBC][4509][SQLAllocHandle.c][840]
Exit:[SQL_SUCCESS]
Output Handle = 0x80673a8
[ODBC][4509][SQLExecDirect.c][200]
Entry:
Statement = 0x80673a8
SQL = [SELECT STATION.description from STATION,
SUBSSTAT, SUBSCRIBER
where SUBSCRIBER.extension=105 and
(SUBSCRIBER.id=SUBSSTA...][length =
185 (SQL_NTS)]
[ODBC][4509][SQLExecDirect.c][425]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLBindCol.c][154]
Entry:
Statement = 0x80673a8
Column Number = 1
Target Type = 1 SQL_CHAR
Target Value = 0xbfffe930
Buffer Length = 80
StrLen Or Ind = 0xbfffed88
[ODBC][4509][SQLBindCol.c][244]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLFetch.c][146]
Entry:
Statement = 0x80673a8
[ODBC][4509][SQLFetch.c][338]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLFreeHandle.c][349]
Entry:
Handle Type = 3
Input Handle = 0x80673a8
[ODBC][4509][SQLFreeHandle.c][450]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLAllocHandle.c][476]
Entry:
Handle Type = 3
Input Handle = 0x805e9b0
[ODBC][4509][SQLAllocHandle.c][840]
Exit:[SQL_SUCCESS]
Output Handle = 0x80673a8
[ODBC][4509][SQLExecDirect.c][200]
Entry:
Statement = 0x80673a8
SQL = [SELECT STATION.description from STATION,
SUBSSTAT, SUBSCRIBER
where SUBSCRIBER.extension=106 and
(SUBSCRIBER.id=SUBSSTA...][length =
185 (SQL_NTS)]
[ODBC][4509][SQLExecDirect.c][425]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLBindCol.c][154]
Entry:
Statement = 0x80673a8
Column Number = 1
Target Type = 1 SQL_CHAR
Target Value = 0xbfffe930
Buffer Length = 80
StrLen Or Ind = 0xbfffed88
[ODBC][4509][SQLBindCol.c][244]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLFetch.c][146]
Entry:
Statement = 0x80673a8
[ODBC][4509][SQLFetch.c][338]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLFreeHandle.c][349]
Entry:
Handle Type = 3
Input Handle = 0x80673a8
[ODBC][4509][SQLFreeHandle.c][450]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLAllocHandle.c][476]
Entry:
Handle Type = 3
Input Handle = 0x805e9b0
[ODBC][4509][SQLAllocHandle.c][840]
Exit:[SQL_SUCCESS]
Output Handle = 0x80673a8
[ODBC][4509][SQLExecDirect.c][200]
Entry:
Statement = 0x80673a8
SQL = [SELECT STATION.description from STATION,
SUBSSTAT, SUBSCRIBER
where SUBSCRIBER.extension=107 and
(SUBSCRIBER.id=SUBSSTA...][length =
185 (SQL_NTS)]
[ODBC][4509][SQLExecDirect.c][425]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLBindCol.c][154]
Entry:
Statement = 0x80673a8
Column Number = 1
Target Type = 1 SQL_CHAR
Target Value = 0xbfffe930
Buffer Length = 80
StrLen Or Ind = 0xbfffed88
[ODBC][4509][SQLBindCol.c][244]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLFetch.c][146]
Entry:
Statement = 0x80673a8
[ODBC][4509][SQLFetch.c][338]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLFreeHandle.c][349]
Entry:
Handle Type = 3
Input Handle = 0x80673a8
[ODBC][4509][SQLFreeHandle.c][450]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLAllocHandle.c][476]
Entry:
Handle Type = 3
Input Handle = 0x805e9b0
[ODBC][4509][SQLAllocHandle.c][840]
Exit:[SQL_SUCCESS]
Output Handle = 0x80673a8
[ODBC][4509][SQLExecDirect.c][200]
Entry:
Statement = 0x80673a8
SQL = [SELECT STATION.description from STATION,
SUBSSTAT, SUBSCRIBER
where SUBSCRIBER.extension=108 and
(SUBSCRIBER.id=SUBSSTA...][length =
185 (SQL_NTS)]
[ODBC][4509][SQLExecDirect.c][425]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLBindCol.c][154]
Entry:
Statement = 0x80673a8
Column Number = 1
Target Type = 1 SQL_CHAR
Target Value = 0xbfffe930
Buffer Length = 80
StrLen Or Ind = 0xbfffed88
[ODBC][4509][SQLBindCol.c][244]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLFetch.c][146]
Entry:
Statement = 0x80673a8
[ODBC][4509][SQLFetch.c][338]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLFreeHandle.c][349]
Entry:
Handle Type = 3
Input Handle = 0x80673a8
[ODBC][4509][SQLFreeHandle.c][450]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLAllocHandle.c][476]
Entry:
Handle Type = 3
Input Handle = 0x805e9b0
[ODBC][4509][SQLAllocHandle.c][840]
Exit:[SQL_SUCCESS]
Output Handle = 0x80673a8
[ODBC][4509][SQLExecDirect.c][200]
Entry:
Statement = 0x80673a8
SQL = [SELECT STATION.description from STATION,
SUBSSTAT, SUBSCRIBER
where SUBSCRIBER.extension=109 and
(SUBSCRIBER.id=SUBSSTA...][length =
185 (SQL_NTS)]
[ODBC][4509][SQLExecDirect.c][425]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLBindCol.c][154]
Entry:
Statement = 0x80673a8
Column Number = 1
Target Type = 1 SQL_CHAR
Target Value = 0xbfffe930
Buffer Length = 80
StrLen Or Ind = 0xbfffed88
[ODBC][4509][SQLBindCol.c][244]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLFetch.c][146]
Entry:
Statement = 0x80673a8
[ODBC][4509][SQLFetch.c][338]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLFreeHandle.c][349]
Entry:
Handle Type = 3
Input Handle = 0x80673a8
[ODBC][4509][SQLFreeHandle.c][450]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLAllocHandle.c][476]
Entry:
Handle Type = 3
Input Handle = 0x805e9b0
[ODBC][4509][SQLAllocHandle.c][840]
Exit:[SQL_SUCCESS]
Output Handle = 0x80673a8
[ODBC][4509][SQLExecDirect.c][200]
Entry:
Statement = 0x80673a8
SQL = [SELECT STATION.description from STATION,
SUBSSTAT, SUBSCRIBER
where SUBSCRIBER.extension=110 and
(SUBSCRIBER.id=SUBSSTA...][length =
185 (SQL_NTS)]
[ODBC][4509][SQLExecDirect.c][425]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLBindCol.c][154]
Entry:
Statement = 0x80673a8
Column Number = 1
Target Type = 1 SQL_CHAR
Target Value = 0xbfffe930
Buffer Length = 80
StrLen Or Ind = 0xbfffed88
[ODBC][4509][SQLBindCol.c][244]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLFetch.c][146]
Entry:
Statement = 0x80673a8
[ODBC][4509][SQLFetch.c][338]
Exit:[SQL_SUCCESS]
[ODBC][4509][SQLFreeHandle.c][349]
Entry:
Handle Type = 3
Input Handle = 0x80673a8
[ODBC][4509][SQLFreeHandle.c][450]
Exit:[SQL_SUCCESS]
regards
--
Vinay Kumar
Software Engineer
Prologix Software Solutions Pvt. Ltd.
Lucknow-226016.India
Ph: +91(522)2721387. Res: 2702453.
Fax: +91(522)2722286
E-Mail: [EMAIL PROTECTED]
Web: www.prologixsoft.com
DISCLAIMER: This e-mail message may contain confidential, proprietary or
legally privileged information which is intended only for the named
recipients above. It should not be used by anyone who is not the original
intended recipient. If you have received this message in error, please delete
it immediately and notify the sender. If you are not the intended recipient,
you are notified that you are strictly prohibited from using, copying,
altering, or disclosing the contents of this message.
The recipient acknowledges that Prologix Software Solutions Pvt. Ltd. is
unable to exercise control or ensure or guarantee the integrity of/over the
contents of the information contained in e-mail transmissions and further
acknowledges that any views expressed in this message are those of the
individual sender and no binding nature of the message shall be implied or
assumed unless the sender does so expressly with due authority of Prologix
Software Solutions Pvt. Ltd.. Prologix accepts no responsibility for loss or
damage arising from the use of the information transmitted by this email
including damage from virus.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
