RE: MySQL transaction support in ATL COM object?

Going for an ATL solution, I would program against ADO and use the
Microsoft OLEDB Provider for ODBC Drivers (known as MSDASQL) so that you
can use the MySQL ODBC driver.

Sample connectstring to pass to ADO would be something like:

Provider=MSDASQL.1;User ID=mrx;Password=*******;Data
Source=MySQL;Initial Catalog=test

With this solution, your ATL component issues SQL statements to ADO,
which passed it on, through ODBC, to the MySQL ODBC driver. You would
have to construct SELECT/INSERT statements in your code dynamically with
string concatenation, etc.

Doing ATL/COM programming against ADO in C++ isn't the easiest thing on
earth if you say you have little experience with OLEDB/Windows. Your
best option would be Google to try to find a helper/wrapper class that
looks suitable for you. If you can't find any, post to this list again
and I can through you a C++ helper class.

BTW: If you only need to copy the data from MS SQL Server to MySQL, why
not use the Data Transformation Services (DTS) feature in Enterprise
Manager? It will copy table, by table, including data, in a wizard like
style. It uses the OLEDB/ODBC way to connect through databases with an
ODBC driver.

/Christer

-----Original Message-----
From: noah@xxxxxxx [mailto:noah@xxxxxxx] 
Sent: Tuesday, August 10, 2004 6:33 PM
To: myodbc@xxxxxxxxxxxxxxx
Subject: 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=christer@xxxxxxxxxxxx




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