Re: Log to MySQL

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Mykhaylo Khodorev (ralfeus_at_chicagocentre.com.ua)
Date: 03/05/04 

Date: Fri, 5 Mar 2004 12:44:14 +0200

I thought ODBC is used as medium interface in order to do not tie to a
single DBMS.... Anyway I've already solved the problem by importing text
file log to the DB by Perl script. Thank you.

"Tony Su" <anonymous@discussions.microsoft.com> ???????/???????? ? ????????
?????????: news:736301c40274$c3afb270$a301280a@phx.gbl...
> Without being able to know exactly what your problem is,
> it looks like MS SQL T-SQL commands are being issued to
> MySQL or you set up the MySQL database and tables using MS
> SQL Stored Procedures.
>
> MS SQL and MySQL speak different dialects.
>
> Maybe someone who has actually setup logging to MySQL can
> shed more light on this.
>
> Tony Su
>
>
>
> >-----Original Message-----
> > Hi,
> > I've tried to set up ISA to log to MySQL database. As
> tutorial I used an
> >article http://isaserver.org/tutorials/mysql.html I could
> create database
> >and tables and DSN. But instead of logging I've got an
> error in application
> >log:
> >Event Type: Error
> >Event Source: Microsoft Web Proxy
> >Event Category: Log
> >Event ID: 6
> >Date: 03.03.2004
> >Time: 22:46:27
> >User: N/A
> >Computer: IRBIS
> >Description:
> >The Microsoft Web Proxy failed to log information to ODBC
> Data Source
> >my_isa_logs, Table: WebProxyLog, under User Name []. The
> ODBC Error
> >description is: [State=37000][Error=1064][MySQL][ODBC 3.51
> >Driver][mysqld-4.0.18-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 'all, -)' at line 1 . For more information about
> this event, see
> >ISA Server Help.
> >
> >What did I do wrong? Or did I miss anything?
> >Thanks
> >Mykhaylo
> >
> >
> >.
> >

Relevant Pages

  • Re: SQL using C
    ... I am almost a new C programmer and now I need to use SQL within my C ... The people who are telling you to use a C API are out of their mind. ... MySQL + PHP), then the MySQL C API is a rather good option to get ... Because ODBC is extremely well documented. ...
    (comp.lang.c)
  • Re: OpenOffice database
    ... I downloaded the java and odbc connectors from mysql, ... today but I will try to find the time to create a MySQL database and access ...
    (alt.os.linux.suse)
  • ODBC Errors In Query
    ... I normally use MySQL with PHP, but I'm delving into connecting to Access ... with ODBC, ... First, if I add an ORDER BY clause, so the query looks like this: ... $sql = "select tblScores.FullName, sumas TotalPoints ...
    (comp.lang.php)
  • Re: GetColAtrribute() with SQL_DESC_OCTET_LENGTH parameter
    ... I am connecting to various RBDMS but primarily SQL ... > Server and MySQL using ODBC 3.0 driver. ...
    (microsoft.public.data.odbc)
  • Re: MySQL from OpenVMS BASIC
    ... for VMS non-C high level languages to use the MySQL C API that they'd ... work with a remote MySQL database; they have a BASIC compiler, ... I'm pretty sure Attunity has ODBC wrappers. ...
    (comp.os.vms)