MySQL transaction support in ATL COM object?

Hi list!

I need to copy data from a Microsoft SQL database to a MySQL 4.0 server
transaction support from a script written in VBscript (Windows Scripting
Host).

To be able to take care of errors and get better control over things i
figured i'd write an in-process COM object in C++ that could be
instantiated in VBscript.

I have virtually no experience with writing OLEDB/ODBC applications in
Windows. To this point i've only interfaced MySQL with libmysql in UNIX
environments.

I'd like to know what libraries/drivers/etc are available that support
transactions that i could use in my ATL COM object to be able to talk
to MySQL. From what i've understood MyOLEDB doesn't support transactions.
I'm not sure how hard it is to use ODBC when you're dealing with ATL.
Would i be able to use MySQL++? Or link my in-process .DLL against
libmysql? [ yes, im new to COM too.. ]

All hints are appreciated, even alternative ways to solve my main problem.
Feel free to contact me off-list in case a reply wouldn't fit in this
forum.

//noah

-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@xxxxxxxxxxx