Hi everyone,I gave this some though a while ago.
I'm looking to execute a script directly on the server with an ODBC
application. Presently I'm using access XP (2002).
If anybody have an idea how I can do this, I'm waiting for it!
From what I understand, you *can* execute scripts from inside the mysql client, but *not* via an ODBC connection.
One way around this is to set up a web server with Perl / PHP scripts ( that optionally accept variables ) and then make access do an http request that triggers the script. Maybe it's not the most efficient way of doing it, and I haven't looked at Access' internet capabilities at all, but I'm pretty sure it will be the easiest way to get the results you want.
MySQL-5 may support running scripts via stored procedures. I haven't looked at this ( the script running bit ) at all.
If anyone has a better idea, feel free to correct me.
Dan
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
