Figured it out... I noticed one day it all of the sudden was working. I was like WTF.. then I realized I had ran the dos window as administrator. Opened a normal user window and sure enough, the script failed. So it's a rights issue. Whew!
Anyone else using a MySQL Connector? Under WinXP, it works fine. I download the connector, install it, then voila.. code works. The relevant part of my code is: Set DB = CreateObject("ADODB.Connection") DB.Open "Driver={MySQL ODBC 3.51 Driver}; Server=sql-server; Port=3306; Option=0...