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]
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak at nusconsulting.com.au
website: http://www.nusconsulting.com.au