When scripting for Windows you have two immediate choices: VBScript and JScript. Both are natively supported by the WSH (Windows Scripting Host) executable which comes in two flavors: command line (cscript.exe) and windowed (wscript.exe). If you want to use Perl or some other scripting language you have to set that up manually.
When I script from Win to MySQL, I use the ADO objects to connect to MySQL via the MySQL ODBC driver. Be aware that the ODBC driver acts like a pre-4.1 client so you will need to perform some security modification to the account you will use to connect your script to the server if you are using a 4.1 server or later. http://www.mysql.com/products/connector/odbc/ http://dev.mysql.com/doc/mysql/en/Old_client.html Use the same basic scripts you would use for coding Web pages with ASP except substitute the "WScript" object for the "Server" object. There are other objects you can use as well. This download will give you both up to date executables and some WSH-specific documentation: http://www.microsoft.com/downloads/details.aspx?FamilyID=c717d943-7e4b-4622-86eb-95a22b832caa&DisplayLang=en Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Chris Mason" <[EMAIL PROTECTED]> wrote on 12/29/2004 07:58:03 AM: > I have a mysql database runing on an internal linux server and I need to > connect to it with an appliication running on a windows workstation. The > application must start another application with command line informaiton > from the database so I canât use a web based application, as web browsers > cannot start an application on the local machine. > I'm looking for recommendations on the easiest way to implement this > project. I would prefer a php like scripting language, I certainly wonât be > able to do it in C or similar. > > Chris Mason > > -- > No virus found in this outgoing message. > Checked by AVG Anti-Virus. > Version: 7.0.296 / Virus Database: 265.6.6 - Release Date: 12/28/2004 > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >
