Syntax error while logging to mysql db

[SgtB]

I'm using MS ISA server, and am trying to configure it to log to a mysql database. MyODBC is installed, and the ISA server can connect (and authenticate) with the mysql server just fine. Once connected, the ISA server tries to insert data, but gets a syntax error response from the mysql server.
The only syntax error in the sent command is the lack of a ';' at the end of the command. The message says the error is near '-)' which is the last two characters in the sent command.
By design I think the ISA server is configured to only log to MS-SQL servers.
Is there a way via the MyODBC driver? Or run-time options for the mysql daemon that may alleviate this problem? It would be pretty bad if this project was scrubbed due to a semicolon.
Thanks!


I'll see your DMCA and raise you a First Amendment.

http://www.anti-dmca.org

 

[abombss]

I have never gotten the MyODBC driver to work for situations like you describe. I tried running DTS packages on our SQL Server to a MySQL server and they always failed while trying to insert data. I don't think the ODBC is very stable, it works for some stuff but not everything.

In light of this fact I use several work arounds.

1) I use Perl DBI wherever I can. I find its fast, easy, and reliable.

2) I take the long way and dump to text files and use the mysqlimport utility to load the data. This is slower and takes disk space if it is a huge load. However you get a back of the raw data which is always nice.

3) I learned MySQL is an awesome tool, but its heavy with Unix mentality and does not always play nice with Win32. I ended up installing Cygwin on all our MySQL servers which run NT or 2K, this helps for scripting and maintenence stuff. -- Don't ask why we can't just use linux.

Good Luck,

abombss

BTW -- I almost left out the best option. MySQL is OSS... Start Hacking!!!!