Privacy Policy

  1. netal.com - Support
  2. Products
  3. SL4NT
  4. Logging to MySQL via ODBC not generating an error
Guest
  • Guest
  • Guest Topic Starter
2006-04-10T17:34:04Z
Date parsed: 4/10/2006 5:34:04 PM
Date: Mon, 10 Apr 2006 16:34:04 +0200

Hi there!
I'm trying to set up SL4NT on a replacement server to log to MySQL rather than an Access database.
I have created a table and set up the ODBC connection, together with an action in SL4NT.
However, when logging commences, i get errors in the event log:

Event ID:50
Inserting a new log record into the table <Syslog> of the database specified by the DSN <SL4NT> failed. ODBC reports the following errors:
37000 [MySQL][ODBC 3.51 Driver][mysqld-5.0.19-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 (Native error code: 1064)

followed by:
Event ID:48
One or more ODBC operations related to the action <Log to MySQL> failed.

for each line attempting to be logged via ODBC.
I have tried turning on logging for the ODBC connector to create a myodbc.log file, but i can't find that file on the filesystem.

How can i troubleshoot the SQL line that is being sent to the ODBC connector?

The MySQL ODBC Connector is v3.51.12, and SL4NT is v3.2. Everything is running locally on a Windows 2000 Professional machine.

Thank you,

Chris


 Reply
Guest
  • Guest
  • Guest Topic Starter
2006-04-10T17:44:33Z
Date parsed: 4/10/2006 5:44:33 PM
Date: Mon, 10 Apr 2006 16:44:33 +0200

Hi Chris,

use the ODBC Data Source Administrator Applet to start logging trace
information into a trace file. Then initiate a SL4NT log operation which
fails. Stop tracing and then send me the trace file.

Franz

"Chris Clemson" <Chris.Clemson@softwareag.co.uk> wrote in message
news:YfpKRvKXGHA.5288@is1.netal.com...
> Hi there!
> I'm trying to set up SL4NT on a replacement server to log to MySQL rather
> than an Access database.
> I have created a table and set up the ODBC connection, together with an
> action in SL4NT.
> However, when logging commences, i get errors in the event log:
>
> Event ID:50
> Inserting a new log record into the table <Syslog> of the database
> specified by the DSN <SL4NT> failed. ODBC reports the following errors:
> 37000 [MySQL][ODBC 3.51 Driver][mysqld-5.0.19-nt]You have an error in
> your SQL syntax; check the manual that corresponds to your MySQL server
> version for the right syntax to use near ')' at line 1 (Native error code:
> 1064)
>
> followed by:
> Event ID:48
> One or more ODBC operations related to the action <Log to MySQL> failed.
>
> for each line attempting to be logged via ODBC.
> I have tried turning on logging for the ODBC connector to create a
> myodbc.log file, but i can't find that file on the filesystem.
>
> How can i troubleshoot the SQL line that is being sent to the ODBC
> connector?
>
> The MySQL ODBC Connector is v3.51.12, and SL4NT is v3.2. Everything is
> running locally on a Windows 2000 Professional machine.
>
> Thank you,
>
> Chris
>
>


 Reply
Guest
  • Guest
  • Guest Topic Starter
2006-04-10T18:24:04Z
Date parsed: 4/10/2006 6:24:04 PM
Date: Mon, 10 Apr 2006 17:24:04 +0200

Franz Krainer <franzk@netal.com> wrote:
> Hi Chris,

Hi Franz,
sorry about the email, i haven't used tin before :(

Below is the log file i get.
On the insert lines, the values are listed as "?", is this normal?


sl4ntsvc a3c-bc4 ENTER SQLAllocEnv
HENV * 2830A560

sl4ntsvc a3c-bc4 EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x2830A560 ( 0x00fe1738)

sl4ntsvc a3c-bc4 ENTER SQLAllocConnect
HENV 00FE1738
HDBC * 005DD7DC

sl4ntsvc a3c-bc4 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 00FE1738
HDBC * 0x005DD7DC ( 0x00fe17e0)

sl4ntsvc a3c-bc4 ENTER SQLConnectW
HDBC 00FE17E0
WCHAR * 0x005DD7F8 [ -3] "SL4NT\ 0"
SWORD -3
WCHAR * 0x1F7C4AA0 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7C4AA0 [ -3] "******\ 0"
SWORD -3

sl4ntsvc a3c-bc4 EXIT SQLConnectW with return code 0 (SQL_SUCCESS)
HDBC 00FE17E0
WCHAR * 0x005DD7F8 [ -3] "SL4NT\ 0"
SWORD -3
WCHAR * 0x1F7C4AA0 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7C4AA0 [ -3] "******\ 0"
SWORD -3

sl4ntsvc a3c-bc4 ENTER SQLAllocStmt
HDBC 00FE17E0
HSTMT * 005D5CCC

sl4ntsvc a3c-bc4 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 00FE17E0
HSTMT * 0x005D5CCC ( 0x00fe1d48)

sl4ntsvc a3c-bc4 ENTER SQLColumnsW
HSTMT 00FE1D48
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x005DB7D0 [ -3] "Sys"
SWORD -3
WCHAR * 0x00000000
SWORD 0

sl4ntsvc a3c-bc4 EXIT SQLColumnsW with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x005DB7D0 [ -3] "Sys"
SWORD -3
WCHAR * 0x00000000
SWORD 0

sl4ntsvc a3c-bc4 ENTER SQLBindCol
HSTMT 00FE1D48
UWORD 4
SWORD -8 <SQL_C_WCHAR>
PTR 0x00FDFD98
SQLLEN 256
SQLLEN * 0x00FDFED8

sl4ntsvc a3c-bc4 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 4
SWORD -8 <SQL_C_WCHAR>
PTR 0x00FDFD98
SQLLEN 256
SQLLEN * 0x00FDFED8 (4001)

sl4ntsvc a3c-bc4 ENTER SQLBindCol
HSTMT 00FE1D48
UWORD 5
SWORD -15 <SQL_C_SSHORT>
PTR 0x00FDFF1E
SQLLEN 2
SQLLEN * 0x00FDFEE0

sl4ntsvc a3c-bc4 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 5
SWORD -15 <SQL_C_SSHORT>
PTR 0x00FDFF1E
SQLLEN 2
SQLLEN * 0x00FDFEE0 (2086205424)

sl4ntsvc a3c-bc4 ENTER SQLBindCol
HSTMT 00FE1D48
UWORD 7
SWORD -16 <SQL_C_SLONG>
PTR 0x00FDFF08
SQLLEN 4
SQLLEN * 0x00FDFEE4

sl4ntsvc a3c-bc4 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 7
SWORD -16 <SQL_C_SLONG>
PTR 0x00FDFF08
SQLLEN 4
SQLLEN * 0x00FDFEE4 (16646052)

sl4ntsvc a3c-bc4 ENTER SQLBindCol
HSTMT 00FE1D48
UWORD 9
SWORD -15 <SQL_C_SSHORT>
PTR 0x00FDFF12
SQLLEN 2
SQLLEN * 0x00FDFEDC

sl4ntsvc a3c-bc4 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 9
SWORD -15 <SQL_C_SSHORT>
PTR 0x00FDFF12
SQLLEN 2
SQLLEN * 0x00FDFEDC (10691800)

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 100 (SQL_NO_DATA_FOUND)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFreeStmt
HSTMT 00FE1D48
UWORD 2 <SQL_UNBIND>

sl4ntsvc a3c-bc4 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 2 <SQL_UNBIND>

sl4ntsvc a3c-bc4 ENTER SQLFreeStmt
HSTMT 00FE1D48
UWORD 0 <SQL_CLOSE>

sl4ntsvc a3c-bc4 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 0 <SQL_CLOSE>

sl4ntsvc a3c-bc4 ENTER SQLPrepareW
HSTMT 00FE1D48
WCHAR * 0x005D9480 [ -3] "insert into Syslog(DateTimeLocal,DateTimeUTC,DateTimeRFC822Local,DateTimeRFC822UTC,IPAddressSource,PortSource,HostnameSource,IPAddressDestination,PortDestination,Facility,FacilityCode,Priority,PriorityCode,MessageText,CustomField1) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\ 0"
SDWORD -3

sl4ntsvc a3c-bc4 EXIT SQLPrepareW with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
WCHAR * 0x005D9480 [ -3] "insert into Syslog(DateTimeLocal,DateTimeUTC,DateTimeRFC822Local,DateTimeRFC822UTC,IPAddressSource,PortSource,HostnameSource,IPAddressDestination,PortDestination,Facility,FacilityCode,Priority,PriorityCode,MessageText,CustomField1) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\ 0"
SDWORD -3

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD 11 <SQL_C_TIMESTAMP>
SWORD 11 <SQL_TIMESTAMP>
SQLULEN 19
SWORD 0
PTR 0x005D7ED8
SQLLEN 16
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD 11 <SQL_C_TIMESTAMP>
SWORD 11 <SQL_TIMESTAMP>
SQLULEN 19
SWORD 0
PTR 0x005D7ED8
SQLLEN 16
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 2
SWORD 1 <SQL_PARAM_INPUT>
SWORD 11 <SQL_C_TIMESTAMP>
SWORD 11 <SQL_TIMESTAMP>
SQLULEN 19
SWORD 0
PTR 0x005D7F18
SQLLEN 16
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 2
SWORD 1 <SQL_PARAM_INPUT>
SWORD 11 <SQL_C_TIMESTAMP>
SWORD 11 <SQL_TIMESTAMP>
SQLULEN 19
SWORD 0
PTR 0x005D7F18
SQLLEN 16
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 3
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 11 <SQL_TIMESTAMP>
SQLULEN 19
SWORD 0
PTR 0x005D7F68
SQLLEN 80
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 3
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 11 <SQL_TIMESTAMP>
SQLULEN 19
SWORD 0
PTR 0x005D7F68
SQLLEN 80
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 4
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 11 <SQL_TIMESTAMP>
SQLULEN 19
SWORD 0
PTR 0x005D7FF8
SQLLEN 80
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 4
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 11 <SQL_TIMESTAMP>
SQLULEN 19
SWORD 0
PTR 0x005D7FF8
SQLLEN 80
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 5
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 15
SWORD 0
PTR 0x005D8078
SQLLEN 32
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 5
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 15
SWORD 0
PTR 0x005D8078
SQLLEN 32
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 6
SWORD 1 <SQL_PARAM_INPUT>
SWORD -17 <SQL_C_USHORT>
SWORD 4 <SQL_INTEGER>
SQLULEN 10
SWORD 0
PTR 0x005D80C8
SQLLEN 12
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 6
SWORD 1 <SQL_PARAM_INPUT>
SWORD -17 <SQL_C_USHORT>
SWORD 4 <SQL_INTEGER>
SQLULEN 10
SWORD 0
PTR 0x005D80C8
SQLLEN 12
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 7
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 150
SWORD 0
PTR 0x005D8108
SQLLEN 302
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 7
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 150
SWORD 0
PTR 0x005D8108
SQLLEN 302
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 8
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 15
SWORD 0
PTR 0x005D8278
SQLLEN 32
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 8
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 15
SWORD 0
PTR 0x005D8278
SQLLEN 32
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 9
SWORD 1 <SQL_PARAM_INPUT>
SWORD -17 <SQL_C_USHORT>
SWORD 4 <SQL_INTEGER>
SQLULEN 10
SWORD 0
PTR 0x005D82C8
SQLLEN 12
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 9
SWORD 1 <SQL_PARAM_INPUT>
SWORD -17 <SQL_C_USHORT>
SWORD 4 <SQL_INTEGER>
SQLULEN 10
SWORD 0
PTR 0x005D82C8
SQLLEN 12
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 10
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 9
SWORD 0
PTR 0x005D8308
SQLLEN 20
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 10
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 9
SWORD 0
PTR 0x005D8308
SQLLEN 20
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 11
SWORD 1 <SQL_PARAM_INPUT>
SWORD -17 <SQL_C_USHORT>
SWORD 5 <SQL_SMALLINT>
SQLULEN 5
SWORD 0
PTR 0x005D8358
SQLLEN 2
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 11
SWORD 1 <SQL_PARAM_INPUT>
SWORD -17 <SQL_C_USHORT>
SWORD 5 <SQL_SMALLINT>
SQLULEN 5
SWORD 0
PTR 0x005D8358
SQLLEN 2
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 12
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 9
SWORD 0
PTR 0x005D8398
SQLLEN 20
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 12
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 9
SWORD 0
PTR 0x005D8398
SQLLEN 20
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 13
SWORD 1 <SQL_PARAM_INPUT>
SWORD -17 <SQL_C_USHORT>
SWORD 5 <SQL_SMALLINT>
SQLULEN 5
SWORD 0
PTR 0x005D83E8
SQLLEN 2
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 13
SWORD 1 <SQL_PARAM_INPUT>
SWORD -17 <SQL_C_USHORT>
SWORD 5 <SQL_SMALLINT>
SQLULEN 5
SWORD 0
PTR 0x005D83E8
SQLLEN 2
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 14
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 1024
SWORD 0
PTR 0x005D8428
SQLLEN 2050
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 14
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 1024
SWORD 0
PTR 0x005D8428
SQLLEN 2050
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 15
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD -6 <SQL_TINYINT>
SQLULEN 1
SWORD 0
PTR 0x005D8C68
SQLLEN 2050
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 15
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD -6 <SQL_TINYINT>
SQLULEN 1
SWORD 0
PTR 0x005D8C68
SQLLEN 2050
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLExecute
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLExecute with return code -1 (SQL_ERROR)
HSTMT 00FE1D48

DIAG [37000] [MySQL][ODBC 3.51 Driver][mysqld-5.0.19-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 (1064)

sl4ntsvc a3c-bc4 ENTER SQLErrorW
HENV 00000000
HDBC 00000000
HSTMT 00FE1D48
WCHAR * 0x00FDFE78 (NYI)
SDWORD * 0x00FDFE94
WCHAR * 0x005D98D0
SWORD 511
SWORD * 0x00FDFE9A

sl4ntsvc a3c-bc4 EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 00000000
HDBC 00000000
HSTMT 00FE1D48
WCHAR * 0x00FDFE78 (NYI)
SDWORD * 0x00FDFE94 (1064)
WCHAR * 0x005D98D0 [ 190] "[MySQL][ODBC 3.51 Driver][mysqld-5.0.19-nt]You have an error in your SQL syntax; check the manu"
SWORD 511
SWORD * 0x00FDFE9A (190)

sl4ntsvc a3c-bc4 ENTER SQLErrorW
HENV 00000000
HDBC 00000000
HSTMT 00FE1D48
WCHAR * 0x00FDFE78 (NYI)
SDWORD * 0x00FDFE94
WCHAR * 0x005D98D0
SWORD 511
SWORD * 0x00FDFE9A

sl4ntsvc a3c-bc4 EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND)
HENV 00000000
HDBC 00000000
HSTMT 00FE1D48
WCHAR * 0x00FDFE78 (NYI)
SDWORD * 0x00FDFE94
WCHAR * 0x005D98D0
SWORD 511
SWORD * 0x00FDFE9A

sl4ntsvc a3c-bc4 ENTER SQLFreeStmt
HSTMT 00FE1D48
UWORD 1 <SQL_DROP>

sl4ntsvc a3c-bc4 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 1 <SQL_DROP>

sl4ntsvc a3c-bc4 ENTER SQLDisconnect
HDBC 00FE17E0

sl4ntsvc a3c-bc4 EXIT SQLDisconnect with return code 0 (SQL_SUCCESS)
HDBC 00FE17E0

sl4ntsvc a3c-bc4 ENTER SQLFreeConnect
HDBC 00FE17E0

sl4ntsvc a3c-bc4 EXIT SQLFreeConnect with return code 0 (SQL_SUCCESS)
HDBC 00FE17E0

sl4ntsvc a3c-bc4 ENTER SQLAllocConnect
HENV 00FE1738
HDBC * 005DD7B4

sl4ntsvc a3c-bc4 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 00FE1738
HDBC * 0x005DD7B4 ( 0x00fe17e0)

sl4ntsvc a3c-bc4 ENTER SQLConnectW
HDBC 00FE17E0
WCHAR * 0x005D82C8 [ -3] "SL4NT\ 0"
SWORD -3
WCHAR * 0x1F7C4AA0 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7C4AA0 [ -3] "******\ 0"
SWORD -3

sl4ntsvc a3c-bc4 EXIT SQLConnectW with return code 0 (SQL_SUCCESS)
HDBC 00FE17E0
WCHAR * 0x005D82C8 [ -3] "SL4NT\ 0"
SWORD -3
WCHAR * 0x1F7C4AA0 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7C4AA0 [ -3] "******\ 0"
SWORD -3

sl4ntsvc a3c-bc4 ENTER SQLAllocStmt
HDBC 00FE17E0
HSTMT * 005D7FD4

sl4ntsvc a3c-bc4 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 00FE17E0
HSTMT * 0x005D7FD4 ( 0x00fe1d48)

sl4ntsvc a3c-bc4 ENTER SQLColumnsW
HSTMT 00FE1D48
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x005DB7D0 [ -3] "Sys"
SWORD -3
WCHAR * 0x00000000
SWORD 0

sl4ntsvc a3c-bc4 EXIT SQLColumnsW with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x005DB7D0 [ -3] "Sys"
SWORD -3
WCHAR * 0x00000000
SWORD 0

sl4ntsvc a3c-bc4 ENTER SQLBindCol
HSTMT 00FE1D48
UWORD 4
SWORD -8 <SQL_C_WCHAR>
PTR 0x00FDFD98
SQLLEN 256
SQLLEN * 0x00FDFED8

sl4ntsvc a3c-bc4 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 4
SWORD -8 <SQL_C_WCHAR>
PTR 0x00FDFD98
SQLLEN 256
SQLLEN * 0x00FDFED8 (672195855)

sl4ntsvc a3c-bc4 ENTER SQLBindCol
HSTMT 00FE1D48
UWORD 5
SWORD -15 <SQL_C_SSHORT>
PTR 0x00FDFF1E
SQLLEN 2
SQLLEN * 0x00FDFEE0

sl4ntsvc a3c-bc4 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 5
SWORD -15 <SQL_C_SSHORT>
PTR 0x00FDFF1E
SQLLEN 2
SQLLEN * 0x00FDFEE0 (0)

sl4ntsvc a3c-bc4 ENTER SQLBindCol
HSTMT 00FE1D48
UWORD 7
SWORD -16 <SQL_C_SLONG>
PTR 0x00FDFF08
SQLLEN 4
SQLLEN * 0x00FDFEE4

sl4ntsvc a3c-bc4 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 7
SWORD -16 <SQL_C_SLONG>
PTR 0x00FDFF08
SQLLEN 4
SQLLEN * 0x00FDFEE4 (6150096)

sl4ntsvc a3c-bc4 ENTER SQLBindCol
HSTMT 00FE1D48
UWORD 9
SWORD -15 <SQL_C_SSHORT>
PTR 0x00FDFF12
SQLLEN 2
SQLLEN * 0x00FDFEDC

sl4ntsvc a3c-bc4 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 9
SWORD -15 <SQL_C_SSHORT>
PTR 0x00FDFF12
SQLLEN 2
SQLLEN * 0x00FDFEDC (6094848)

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 100 (SQL_NO_DATA_FOUND)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFreeStmt
HSTMT 00FE1D48
UWORD 2 <SQL_UNBIND>

sl4ntsvc a3c-bc4 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 2 <SQL_UNBIND>

sl4ntsvc a3c-bc4 ENTER SQLFreeStmt
HSTMT 00FE1D48
UWORD 0 <SQL_CLOSE>

sl4ntsvc a3c-bc4 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 0 <SQL_CLOSE>

sl4ntsvc a3c-bc4 ENTER SQLPrepareW
HSTMT 00FE1D48
WCHAR * 0x005D96A8 [ -3] "insert into Syslog(DateTimeLocal,DateTimeUTC,DateTimeRFC822Local,DateTimeRFC822UTC,IPAddressSource,PortSource,HostnameSource,IPAddressDestination,PortDestination,Facility,FacilityCode,Priority,PriorityCode,MessageText,CustomField1) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\ 0"
SDWORD -3

sl4ntsvc a3c-bc4 EXIT SQLPrepareW with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
WCHAR * 0x005D96A8 [ -3] "insert into Syslog(DateTimeLocal,DateTimeUTC,DateTimeRFC822Local,DateTimeRFC822UTC,IPAddressSource,PortSource,HostnameSource,IPAddressDestination,PortDestination,Facility,FacilityCode,Priority,PriorityCode,MessageText,CustomField1) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\ 0"
SDWORD -3

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD 11 <SQL_C_TIMESTAMP>
SWORD 11 <SQL_TIMESTAMP>
SQLULEN 19
SWORD 0
PTR 0x005D80C8
SQLLEN 16
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD 11 <SQL_C_TIMESTAMP>
SWORD 11 <SQL_TIMESTAMP>
SQLULEN 19
SWORD 0
PTR 0x005D80C8
SQLLEN 16
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 2
SWORD 1 <SQL_PARAM_INPUT>
SWORD 11 <SQL_C_TIMESTAMP>
SWORD 11 <SQL_TIMESTAMP>
SQLULEN 19
SWORD 0
PTR 0x005D7F18
SQLLEN 16
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 2
SWORD 1 <SQL_PARAM_INPUT>
SWORD 11 <SQL_C_TIMESTAMP>
SWORD 11 <SQL_TIMESTAMP>
SQLULEN 19
SWORD 0
PTR 0x005D7F18
SQLLEN 16
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 3
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 11 <SQL_TIMESTAMP>
SQLULEN 19
SWORD 0
PTR 0x005D7FF8
SQLLEN 80
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 3
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 11 <SQL_TIMESTAMP>
SQLULEN 19
SWORD 0
PTR 0x005D7FF8
SQLLEN 80
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 4
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 11 <SQL_TIMESTAMP>
SQLULEN 19
SWORD 0
PTR 0x005D7F68
SQLLEN 80
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 4
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 11 <SQL_TIMESTAMP>
SQLULEN 19
SWORD 0
PTR 0x005D7F68
SQLLEN 80
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 5
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 15
SWORD 0
PTR 0x005D8078
SQLLEN 32
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 5
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 15
SWORD 0
PTR 0x005D8078
SQLLEN 32
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 6
SWORD 1 <SQL_PARAM_INPUT>
SWORD -17 <SQL_C_USHORT>
SWORD 4 <SQL_INTEGER>
SQLULEN 10
SWORD 0
PTR 0x005D7ED8
SQLLEN 12
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 6
SWORD 1 <SQL_PARAM_INPUT>
SWORD -17 <SQL_C_USHORT>
SWORD 4 <SQL_INTEGER>
SQLULEN 10
SWORD 0
PTR 0x005D7ED8
SQLLEN 12
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 7
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 150
SWORD 0
PTR 0x005D8108
SQLLEN 302
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 7
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 150
SWORD 0
PTR 0x005D8108
SQLLEN 302
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 8
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 15
SWORD 0
PTR 0x005D82A0
SQLLEN 32
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 8
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 15
SWORD 0
PTR 0x005D82A0
SQLLEN 32
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 9
SWORD 1 <SQL_PARAM_INPUT>
SWORD -17 <SQL_C_USHORT>
SWORD 4 <SQL_INTEGER>
SQLULEN 10
SWORD 0
PTR 0x005DD808
SQLLEN 12
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 9
SWORD 1 <SQL_PARAM_INPUT>
SWORD -17 <SQL_C_USHORT>
SWORD 4 <SQL_INTEGER>
SQLULEN 10
SWORD 0
PTR 0x005DD808
SQLLEN 12
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 10
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 9
SWORD 0
PTR 0x005DAB28
SQLLEN 20
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 10
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 9
SWORD 0
PTR 0x005DAB28
SQLLEN 20
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 11
SWORD 1 <SQL_PARAM_INPUT>
SWORD -17 <SQL_C_USHORT>
SWORD 5 <SQL_SMALLINT>
SQLULEN 5
SWORD 0
PTR 0x005DAB78
SQLLEN 2
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 11
SWORD 1 <SQL_PARAM_INPUT>
SWORD -17 <SQL_C_USHORT>
SWORD 5 <SQL_SMALLINT>
SQLULEN 5
SWORD 0
PTR 0x005DAB78
SQLLEN 2
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 12
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 9
SWORD 0
PTR 0x005DABB8
SQLLEN 20
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 12
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 9
SWORD 0
PTR 0x005DABB8
SQLLEN 20
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 13
SWORD 1 <SQL_PARAM_INPUT>
SWORD -17 <SQL_C_USHORT>
SWORD 5 <SQL_SMALLINT>
SQLULEN 5
SWORD 0
PTR 0x005DAC08
SQLLEN 2
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 13
SWORD 1 <SQL_PARAM_INPUT>
SWORD -17 <SQL_C_USHORT>
SWORD 5 <SQL_SMALLINT>
SQLULEN 5
SWORD 0
PTR 0x005DAC08
SQLLEN 2
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 14
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 1024
SWORD 0
PTR 0x005D8950
SQLLEN 2050
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 14
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 1024
SWORD 0
PTR 0x005D8950
SQLLEN 2050
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 15
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD -6 <SQL_TINYINT>
SQLULEN 1
SWORD 0
PTR 0x005D6C70
SQLLEN 2050
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 15
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD -6 <SQL_TINYINT>
SQLULEN 1
SWORD 0
PTR 0x005D6C70
SQLLEN 2050
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLExecute
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLExecute with return code -1 (SQL_ERROR)
HSTMT 00FE1D48

DIAG [37000] [MySQL][ODBC 3.51 Driver][mysqld-5.0.19-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 (1064)

sl4ntsvc a3c-bc4 ENTER SQLErrorW
HENV 00000000
HDBC 00000000
HSTMT 00FE1D48
WCHAR * 0x00FDFE78 (NYI)
SDWORD * 0x00FDFE94
WCHAR * 0x005D7488
SWORD 511
SWORD * 0x00FDFE9A

sl4ntsvc a3c-bc4 EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 00000000
HDBC 00000000
HSTMT 00FE1D48
WCHAR * 0x00FDFE78 (NYI)
SDWORD * 0x00FDFE94 (1064)
WCHAR * 0x005D7488 [ 190] "[MySQL][ODBC 3.51 Driver][mysqld-5.0.19-nt]You have an error in your SQL syntax; check the manu"
SWORD 511
SWORD * 0x00FDFE9A (190)

sl4ntsvc a3c-bc4 ENTER SQLErrorW
HENV 00000000
HDBC 00000000
HSTMT 00FE1D48
WCHAR * 0x00FDFE78 (NYI)
SDWORD * 0x00FDFE94
WCHAR * 0x005D7488
SWORD 511
SWORD * 0x00FDFE9A

sl4ntsvc a3c-bc4 EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND)
HENV 00000000
HDBC 00000000
HSTMT 00FE1D48
WCHAR * 0x00FDFE78 (NYI)
SDWORD * 0x00FDFE94
WCHAR * 0x005D7488
SWORD 511
SWORD * 0x00FDFE9A

sl4ntsvc a3c-bc4 ENTER SQLFreeStmt
HSTMT 00FE1D48
UWORD 1 <SQL_DROP>

sl4ntsvc a3c-bc4 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 1 <SQL_DROP>

sl4ntsvc a3c-bc4 ENTER SQLDisconnect
HDBC 00FE17E0

sl4ntsvc a3c-bc4 EXIT SQLDisconnect with return code 0 (SQL_SUCCESS)
HDBC 00FE17E0

sl4ntsvc a3c-bc4 ENTER SQLFreeConnect
HDBC 00FE17E0

sl4ntsvc a3c-bc4 EXIT SQLFreeConnect with return code 0 (SQL_SUCCESS)
HDBC 00FE17E0

sl4ntsvc a3c-bc4 ENTER SQLAllocConnect
HENV 00FE1738
HDBC * 005D7EBC

sl4ntsvc a3c-bc4 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 00FE1738
HDBC * 0x005D7EBC ( 0x00fe17e0)

sl4ntsvc a3c-bc4 ENTER SQLConnectW
HDBC 00FE17E0
WCHAR * 0x005DD808 [ -3] "SL4NT\ 0"
SWORD -3
WCHAR * 0x1F7C4AA0 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7C4AA0 [ -3] "******\ 0"
SWORD -3

sl4ntsvc a3c-bc4 EXIT SQLConnectW with return code 0 (SQL_SUCCESS)
HDBC 00FE17E0
WCHAR * 0x005DD808 [ -3] "SL4NT\ 0"
SWORD -3
WCHAR * 0x1F7C4AA0 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7C4AA0 [ -3] "******\ 0"
SWORD -3

sl4ntsvc a3c-bc4 ENTER SQLAllocStmt
HDBC 00FE17E0
HSTMT * 005D7FD4

sl4ntsvc a3c-bc4 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 00FE17E0
HSTMT * 0x005D7FD4 ( 0x00fe1d48)

sl4ntsvc a3c-bc4 ENTER SQLColumnsW
HSTMT 00FE1D48
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x005DB7D0 [ -3] "Sys"
SWORD -3
WCHAR * 0x00000000
SWORD 0

sl4ntsvc a3c-bc4 EXIT SQLColumnsW with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x005DB7D0 [ -3] "Sys"
SWORD -3
WCHAR * 0x00000000
SWORD 0

sl4ntsvc a3c-bc4 ENTER SQLBindCol
HSTMT 00FE1D48
UWORD 4
SWORD -8 <SQL_C_WCHAR>
PTR 0x00FDFD98
SQLLEN 256
SQLLEN * 0x00FDFED8

sl4ntsvc a3c-bc4 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 4
SWORD -8 <SQL_C_WCHAR>
PTR 0x00FDFD98
SQLLEN 256
SQLLEN * 0x00FDFED8 (672195855)

sl4ntsvc a3c-bc4 ENTER SQLBindCol
HSTMT 00FE1D48
UWORD 5
SWORD -15 <SQL_C_SSHORT>
PTR 0x00FDFF1E
SQLLEN 2
SQLLEN * 0x00FDFEE0

sl4ntsvc a3c-bc4 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 5
SWORD -15 <SQL_C_SSHORT>
PTR 0x00FDFF1E
SQLLEN 2
SQLLEN * 0x00FDFEE0 (0)

sl4ntsvc a3c-bc4 ENTER SQLBindCol
HSTMT 00FE1D48
UWORD 7
SWORD -16 <SQL_C_SLONG>
PTR 0x00FDFF08
SQLLEN 4
SQLLEN * 0x00FDFEE4

sl4ntsvc a3c-bc4 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 7
SWORD -16 <SQL_C_SLONG>
PTR 0x00FDFF08
SQLLEN 4
SQLLEN * 0x00FDFEE4 (6150056)

sl4ntsvc a3c-bc4 ENTER SQLBindCol
HSTMT 00FE1D48
UWORD 9
SWORD -15 <SQL_C_SSHORT>
PTR 0x00FDFF12
SQLLEN 2
SQLLEN * 0x00FDFEDC

sl4ntsvc a3c-bc4 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 9
SWORD -15 <SQL_C_SSHORT>
PTR 0x00FDFF12
SQLLEN 2
SQLLEN * 0x00FDFEDC (6094848)

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFetch
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 EXIT SQLFetch with return code 100 (SQL_NO_DATA_FOUND)
HSTMT 00FE1D48

sl4ntsvc a3c-bc4 ENTER SQLFreeStmt
HSTMT 00FE1D48
UWORD 2 <SQL_UNBIND>

sl4ntsvc a3c-bc4 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 2 <SQL_UNBIND>

sl4ntsvc a3c-bc4 ENTER SQLFreeStmt
HSTMT 00FE1D48
UWORD 0 <SQL_CLOSE>

sl4ntsvc a3c-bc4 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 0 <SQL_CLOSE>

sl4ntsvc a3c-bc4 ENTER SQLPrepareW
HSTMT 00FE1D48
WCHAR * 0x005D9480 [ -3] "insert into Syslog(DateTimeLocal,DateTimeUTC,DateTimeRFC822Local,DateTimeRFC822UTC,IPAddressSource,PortSource,HostnameSource,IPAddressDestination,PortDestination,Facility,FacilityCode,Priority,PriorityCode,MessageText,CustomField1) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\ 0"
SDWORD -3

sl4ntsvc a3c-bc4 EXIT SQLPrepareW with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
WCHAR * 0x005D9480 [ -3] "insert into Syslog(DateTimeLocal,DateTimeUTC,DateTimeRFC822Local,DateTimeRFC822UTC,IPAddressSource,PortSource,HostnameSource,IPAddressDestination,PortDestination,Facility,FacilityCode,Priority,PriorityCode,MessageText,CustomField1) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\ 0"
SDWORD -3

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD 11 <SQL_C_TIMESTAMP>
SWORD 11 <SQL_TIMESTAMP>
SQLULEN 19
SWORD 0
PTR 0x005D7ED8
SQLLEN 16
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD 11 <SQL_C_TIMESTAMP>
SWORD 11 <SQL_TIMESTAMP>
SQLULEN 19
SWORD 0
PTR 0x005D7ED8
SQLLEN 16
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 2
SWORD 1 <SQL_PARAM_INPUT>
SWORD 11 <SQL_C_TIMESTAMP>
SWORD 11 <SQL_TIMESTAMP>
SQLULEN 19
SWORD 0
PTR 0x005D7F18
SQLLEN 16
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 2
SWORD 1 <SQL_PARAM_INPUT>
SWORD 11 <SQL_C_TIMESTAMP>
SWORD 11 <SQL_TIMESTAMP>
SQLULEN 19
SWORD 0
PTR 0x005D7F18
SQLLEN 16
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 3
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 11 <SQL_TIMESTAMP>
SQLULEN 19
SWORD 0
PTR 0x005D7F68
SQLLEN 80
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 3
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 11 <SQL_TIMESTAMP>
SQLULEN 19
SWORD 0
PTR 0x005D7F68
SQLLEN 80
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 4
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 11 <SQL_TIMESTAMP>
SQLULEN 19
SWORD 0
PTR 0x005D7FF8
SQLLEN 80
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 4
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 11 <SQL_TIMESTAMP>
SQLULEN 19
SWORD 0
PTR 0x005D7FF8
SQLLEN 80
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 5
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 15
SWORD 0
PTR 0x005D8088
SQLLEN 32
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 00FE1D48
UWORD 5
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 15
SWORD 0
PTR 0x005D8088
SQLLEN 32
SQLLEN * 0x00000000

sl4ntsvc a3c-bc4 ENTER SQLBindParameter
HSTMT 00FE1D48
UWORD 6
SWORD 1 <SQL_PARAM_INPUT>
SWORD -17 <SQL_C_USHORT>
SWORD 4 <SQL_INTEGER>
SQLULEN 10
SWORD 0
PTR 0x005D80C8
SQLLEN 12
SQLLEN * 0x00000000

sl4ntsvc ...
 Reply
Guest
  • Guest
  • Guest Topic Starter
2006-04-10T18:31:05Z
Date parsed: 4/10/2006 6:31:05 PM
Date: Mon, 10 Apr 2006 17:31:05 +0200

I think i might have found the problem,
please don't spend any time on diagnosing my problem until i get back to you!
i'm going to try something with my table.
thanks,

chris

 Reply
Guest
  • Guest
  • Guest Topic Starter
2006-04-10T18:49:41Z
Date parsed: 4/10/2006 6:49:41 PM
Date: Mon, 10 Apr 2006 17:49:41 +0200

Hi Franz,
I've found the problem - I had a CustomField that wasn't CHAR oops!
I've renamed it and it's logging fine.
Thank you!

chris

 Reply
Similar Topics
  1. netal.com - Support
  2. Products
  3. SL4NT
  4. Logging to MySQL via ODBC not generating an error