Skip to Content.
Sympa Menu

freetds - Re: [freetds] ODBC log from error 778672

Please Wait...

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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





Archive powered by MHonArc 2.6.24.

Top of Page