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