[unixODBC-support] unixODBC/FreeTDS/PHP 4.3.11 some of my odbc_exec statements fail.

Joe McMillan joe.mcmillan at dciasp.com
Mon Apr 18 22:24:44 BST 2005


I was wondering if anyone had seen this before.. some of my odbc_exec()
statements aren't working but others are fine.. the SQL queries work tine in
isql and tsql. Just not in PHP odbc_*. hope someone can help.

 

::::::SNIP FROM SQL.LOG::::::

 

[ODBC][47307][SQLColAttributes.c][267]
               Entry:            
                       Statement = 0x851c800            
                       Column Number = 1            
                       Field Identifier = SQL_COLUMN_NAME            
                       Character Attr = 0x85b528c            
                       Buffer Length = 32            
                       String Length = 0xbfbfa13a            
                       Numeric Attribute = 0x0
[ODBC][47307][SQLColAttributes.c][584]
               Exit:[SQL_SUCCESS]
[ODBC][47307][SQLColAttributes.c][267]
               Entry:            
                       Statement = 0x851c800            
                       Column Number = 1            
                       Field Identifier = SQL_DESC_CONCISE_TYPE            
                       Character Attr = 0x0            
                       Buffer Length = 0            
                       String Length = 0x0            
                       Numeric Attribute = 0x85b52b4
[ODBC][47307][SQLColAttributes.c][584]
               Exit:[SQL_SUCCESS]
[ODBC][47307][SQLColAttributes.c][267]
               Entry:            
                       Statement = 0x851c800            
                       Column Number = 1            
                       Field Identifier = SQL_DESC_DISPLAY_SIZE            
                       Character Attr = 0x0            
                       Buffer Length = 0            
                       String Length = 0x0            
                       Numeric Attribute = 0xbfbfa134
[ODBC][47307][SQLColAttributes.c][584]
               Exit:[SQL_SUCCESS]
[ODBC][47307][SQLBindCol.c][165]
               Entry:            
                       Statement = 0x851c800            
                       Column Number = 1            
                       Target Type = 1 SQL_CHAR            
                       Target Value = 0x8209a0c            
                       Buffer Length = 31            
                       StrLen Or Ind = 0x85b52b0
[ODBC][47307][SQLBindCol.c][251]
               Exit:[SQL_SUCCESS]
[ODBC][47307][SQLExtendedFetch.c][159]
               Entry:            
                       Statement = 0x851c800            
                       Fetch Type = 1            
                       Row = 1            
                       PcRow = 0xbfbfa16c            
                       Row Status = 0xbfbfa172
[ODBC][47307][SQLExtendedFetch.c][316]
               Exit:[SQL_SUCCESS]
[ODBC][47307][SQLAllocHandle.c][510]
               Entry:
                       Handle Type = 3
                       Input Handle = 0x851d000
[ODBC][47307][SQLAllocHandle.c][872]
               Exit:[SQL_SUCCESS]
                       Output Handle = 0x8568800
[ODBC][47307][SQLGetInfo.c][214]
               Entry:            
                       Connection = 0x851d000            
                       Info Type = SQL_FETCH_DIRECTION (8)            
                       Info Value = 0xbfbfa16c            
                       Buffer Length = 4            
                       StrLen = 0x0
[ODBC][47307][SQLGetInfo.c][528]
               Exit:[SQL_SUCCESS]
[ODBC][47307][SQLSetStmtOption.c][174]
               Entry:            
                       Statement = 0x8568800            
                       Option = SQL_ATTR_CURSOR_TYPE            
                       Value = 2
[ODBC][47307][SQLSetStmtOption.c][370]
               Exit:[SQL_SUCCESS_WITH_INFO]
[ODBC][47307][SQLExecDirect.c][233]
               Entry:            
                       Statement = 0x8568800            
                       SQL = [SELECT
login_type='E',emp_code=emp_code,employeeid=empid,login_flag='P',emp_lastnam
e,emp_firstname  FROM emp_employees, sec_logi...][length = 523 (SQL_NTS)]
[ODBC][47307][SQLExecDirect.c][496]
               Exit:[SQL_ERROR]
[ODBC][47307][SQLError.c][342]
               Entry:                
                       Statement = 0x8568800                
                       SQLState = 0xbfbfa120                
                       Native = 0xbfbf9f18                
                       Message Text = 0xbfbf9f20                
                       Buffer Length = 511                
                       Text Len Ptr = 0xbfbf9f1e
[ODBC][47307][SQLError.c][379]
               Exit:[SQL_NO_DATA]
[ODBC][47307][SQLFreeStmt.c][140]
               Entry:            
                       Statement = 0x8568800            
                       Option = 1
[ODBC][47307][SQLFreeHandle.c][365]
               Entry:
                       Handle Type = 3
                       Input Handle = 0x8568800
[ODBC][47307][SQLFreeHandle.c][462]
               Exit:[SQL_SUCCESS]
[ODBC][47307][SQLFreeStmt.c][140]
               Entry:            
                       Statement = 0x851c800            
                       Option = 1
[ODBC][47307][SQLFreeHandle.c][365]
               Entry:
                       Handle Type = 3
                       Input Handle = 0x851c800
[ODBC][47307][SQLFreeHandle.c][462]
               Exit:[SQL_SUCCESS]
[ODBC][47307][SQLAllocHandle.c][510]
               Entry:
                       Handle Type = 3
                       Input Handle = 0x851d000
[ODBC][47307][SQLAllocHandle.c][872]
               Exit:[SQL_SUCCESS]
                       Output Handle = 0x851c800
[ODBC][47307][SQLGetInfo.c][214]
               Entry:            
                       Connection = 0x851d000            
                       Info Type = SQL_FETCH_DIRECTION (8)            
                       Info Value = 0xbfbfa16c            
                       Buffer Length = 4            
                       StrLen = 0x0
[ODBC][47307][SQLGetInfo.c][528]
               Exit:[SQL_SUCCESS]

 

 

Thanks

 

Joe McMillan

Data Consultants INC.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20050418/a6fcc19b/attachment.html>


More information about the unixODBC-support mailing list