freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
- To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
- Subject: Re: [freetds] ODBC log from error 778672
- Date: Wed, 17 May 2006 13:46:49 +0200
>
> I've just realised that I omitted the all-important log.
> Many, many apologies.
>
> Here it is:
>
> [ODBC][9783][SQLAllocHandle.c][510]
> Entry:
> Handle Type = 3
> Input Handle = 0x874f900
> [ODBC][9783][SQLAllocHandle.c][872]
> Exit:[SQL_SUCCESS]
> Output Handle = 0x8a9ea00
> [ODBC][9783][SQLPrepare.c][189]
> Entry:
> Statement = 0x8a9ea00
> SQL = [insert into Contacts ( Salutations,
> FirstName, LastName, Title, Area, PhoneSTD, PhoneNo, FaxSTD, Fax
> No, Mobile, Email, BulkEmai...][length = 189]
> [ODBC][9783][SQLPrepare.c][364]
> Exit:[SQL_SUCCESS]
> [ODBC][9783][SQLFreeStmt.c][140]
> Entry:
> Statement = 0x8a9ea00
> Option = 3
> [ODBC][9783][SQLFreeStmt.c][246]
> Exit:[SQL_SUCCESS]
> [ODBC][9783][SQLBindParameter.c][193]
> Entry:
> Statement = 0x8a9ea00
> Param Number = 6
> Param Type = 1
> C Type = 1 SQL_C_CHAR
> SQL Type = 12 SQL_VARCHAR
> Col Def = 80
> Scale = 0
> Rgb Value = 0x8a843d0
> Value Max = 2
> StrLen Or Ind = 0x894cac0
> [ODBC][9783][SQLBindParameter.c][339]
> Exit:[SQL_SUCCESS]
> [ODBC][9783][SQLBindParameter.c][193]
> Entry:
> Statement = 0x8a9ea00
> Param Number = 11
> Param Type = 1
> C Type = 1 SQL_C_CHAR
> SQL Type = 12 SQL_VARCHAR
> Col Def = 80
> Scale = 0
> Rgb Value = 0x8a64e00
> Value Max = 25
> StrLen Or Ind = 0x8a9abc0
> [ODBC][9783][SQLBindParameter.c][339]
> Exit:[SQL_SUCCESS]
> [ODBC][9783][SQLBindParameter.c][193]
> Entry:
> Statement = 0x8a9ea00
> Param Number = 3
> Param Type = 1
> C Type = 1 SQL_C_CHAR
> SQL Type = 12 SQL_VARCHAR
> Col Def = 80
> Scale = 0
> Rgb Value = 0x8a1bb60
> Value Max = 6
> StrLen Or Ind = 0x8a80130
> [ODBC][9783][SQLBindParameter.c][339]
> Exit:[SQL_SUCCESS]
> [ODBC][9783][SQLBindParameter.c][193]
> Entry:
> Statement = 0x8a9ea00
> Param Number = 7
> Param Type = 1
> C Type = 1 SQL_C_CHAR
> SQL Type = 12 SQL_VARCHAR
> Col Def = 80
> Scale = 0
> Rgb Value = 0x8a14f88
> Value Max = 8
> StrLen Or Ind = 0x8a94130
> [ODBC][9783][SQLBindParameter.c][339]
> Exit:[SQL_SUCCESS]
> [ODBC][9783][SQLBindParameter.c][193]
> Entry:
> Statement = 0x8a9ea00
> Param Number = 9
> Param Type = 1
> C Type = 1 SQL_C_CHAR
> SQL Type = 12 SQL_VARCHAR
> Col Def = 80
> Scale = 0
> Rgb Value = 0x8a7ddb8
> Value Max = 8
> StrLen Or Ind = 0x8a9ab30
> [ODBC][9783][SQLBindParameter.c][339]
> Exit:[SQL_SUCCESS]
> [ODBC][9783][SQLBindParameter.c][193]
> Entry:
> Statement = 0x8a9ea00
> Param Number = 12
> Param Type = 1
> C Type = 1 SQL_C_CHAR
> SQL Type = 12 SQL_VARCHAR
> Col Def = 80
> Scale = 0
> Rgb Value = 0x8a60768
> Value Max = 1
> StrLen Or Ind = 0x8a9d030
> [ODBC][9783][SQLBindParameter.c][339]
> Exit:[SQL_SUCCESS]
> [ODBC][9783][SQLBindParameter.c][193]
> Entry:
> Statement = 0x8a9ea00
> Param Number = 2
> Param Type = 1
> C Type = 1 SQL_C_CHAR
> SQL Type = 12 SQL_VARCHAR
> Col Def = 80
> Scale = 0
> Rgb Value = 0x8a894e8
> Value Max = 4
> StrLen Or Ind = 0x8a87740
> [ODBC][9783][SQLBindParameter.c][339]
> Exit:[SQL_SUCCESS]
> [ODBC][9783][SQLBindParameter.c][193]
> Entry:
> Statement = 0x8a9ea00
> Param Number = 8
> Param Type = 1
> C Type = 1 SQL_C_CHAR
> SQL Type = 12 SQL_VARCHAR
> Col Def = 80
> Scale = 0
> Rgb Value = 0x8a14f98
> Value Max = 2
> StrLen Or Ind = 0x8a94178
> [ODBC][9783][SQLBindParameter.c][339]
> Exit:[SQL_SUCCESS]
> [ODBC][9783][SQLBindParameter.c][193]
> Entry:
> Statement = 0x8a9ea00
> Param Number = 1
> Param Type = 1
> C Type = 1 SQL_C_CHAR
> SQL Type = 12 SQL_VARCHAR
> Col Def = 80
> Scale = 0
> Rgb Value = 0x89878a0
> Value Max = 2
> StrLen Or Ind = 0x8a79918
> [ODBC][9783][SQLBindParameter.c][339]
> Exit:[SQL_SUCCESS]
> [ODBC][9783][SQLBindParameter.c][193]
> Entry:
> Statement = 0x8a9ea00
> Param Number = 4
> Param Type = 1
> C Type = 1 SQL_C_CHAR
> SQL Type = 12 SQL_VARCHAR
> Col Def = 80
> Scale = 0
> Rgb Value = 0x8a1bb70
> Value Max = 6
> StrLen Or Ind = 0x8a80178
> [ODBC][9783][SQLBindParameter.c][339]
> Exit:[SQL_SUCCESS]
> [ODBC][9783][SQLBindParameter.c][193]
> Entry:
> Statement = 0x8a9ea00
> Param Number = 13
> Param Type = 1
> C Type = 1 SQL_C_CHAR
> SQL Type = 12 SQL_VARCHAR
> Col Def = 80
> Scale = 0
> Rgb Value = 0x8a60758
> Value Max = 1
> StrLen Or Ind = 0x8a9d078
> [ODBC][9783][SQLBindParameter.c][339]
> Exit:[SQL_SUCCESS]
> [ODBC][9783][SQLBindParameter.c][193]
> Entry:
> Statement = 0x8a9ea00
> Param Number = 10
> Param Type = 1
> C Type = 1 SQL_C_CHAR
> SQL Type = 12 SQL_VARCHAR
> Col Def = 80
> Scale = 0
> Rgb Value = 0x8a7ddc8
> Value Max = 10
> StrLen Or Ind = 0x8a9ab78
> [ODBC][9783][SQLBindParameter.c][339]
> Exit:[SQL_SUCCESS]
> [ODBC][9783][SQLBindParameter.c][193]
> Entry:
> Statement = 0x8a9ea00
> Param Number = 5
> Param Type = 1
> C Type = 1 SQL_C_CHAR
> SQL Type = 12 SQL_VARCHAR
> Col Def = 80
> Scale = 0
> Rgb Value = 0x8a843c0
> Value Max = 4
> StrLen Or Ind = 0x894ca78
> [ODBC][9783][SQLBindParameter.c][339]
> Exit:[SQL_SUCCESS]
> [ODBC][9783][SQLExecute.c][183]
> Entry:
> Statement = 0x8a9ea00
> [ODBC][9783][SQLExecute.c][344]
> Exit:[SQL_ERROR]
> DIAG [42000] [FreeTDS][SQL Server]RAISERROR could not
> locate entry for error 778672 in sysmessages.
>
> [ODBC][9783][SQLError.c][342]
> Entry:
> Statement = 0x8a9ea00
> SQLState = 0xbf99e830
> Native = 0xbf99e618
> Message Text = 0xbf99e630
> Buffer Length = 511
> Text Len Ptr = 0xbf99e61e
> [ODBC][9783][SQLError.c][379]
> Exit:[SQL_SUCCESS]
> SQLState = 42000
> Native = 0xbf99e618 -> 2758
> Message Text = [[unixODBC][FreeTDS][SQL
> Server]RAISERROR could not locate entry for error 778672 in sysmessa
> ges.]
> [ODBC][9783][SQLError.c][342]
> Entry:
> Statement = 0x8a9ea00
> SQLState = 0xbf99e830
> Native = 0xbf99e618
> Message Text = 0xbf99e630
> Buffer Length = 511
> Text Len Ptr = 0xbf99e61e
> [ODBC][9783][SQLError.c][379]
> Exit:[SQL_NO_DATA]
> [ODBC][9783][SQLError.c][424]
> Entry:
> Connection = 0x874f900
> SQLState = 0xbf99e830
> Native = 0xbf99e618
> Message Text = 0xbf99e630
> Buffer Length = 511
> Text Len Ptr = 0xbf99e61e
> [ODBC][9783][SQLError.c][461]
> Exit:[SQL_NO_DATA]
> [ODBC][9783][SQLError.c][504]
> Entry:
> Environment = 0x874f370
> SQLState = 0xbf99e830
> Native = 0xbf99e618
> Message Text = 0xbf99e630
> Buffer Length = 511
> Text Len Ptr = 0xbf99e61e
> [ODBC][9783][SQLError.c][541]
> Exit:[SQL_NO_DATA]
> [ODBC][9783][SQLFreeHandle.c][365]
> Entry:
> Handle Type = 3
> Input Handle = 0x8a9ea00
> [ODBC][9783][SQLFreeHandle.c][462]
> Exit:[SQL_SUCCESS]
>
Hi Daniel,
you are on the right mailing list. Calls seems correct (although I
cannot see entire query), 13 parameters are used in query and 13
parameters are binded. The error is very strange... it seems that mssql
detect some error but is not able to get that error... very strange. It
would be helpful a freetds log.
freddy77
-
[freetds] ODBC log from error 778672,
Daniel Kasak, 05/16/2006
- <Possible follow-up(s)>
-
Re: [freetds] ODBC log from error 778672,
ZIGLIO, Frediano, VF-IT, 05/17/2006
- Re: [freetds] ODBC log from error 778672, Daniel Kasak, 05/17/2006
Archive powered by MHonArc 2.6.24.