This is my Blog.

It's full of opinions on a wide range of stuff.

Working MySQL 5 OLEDB Connectivity for XMPie Server

Well, after a long stint of having no decent MySQL support (as uProduce only supports up to version 4 out of the box. Other than my ODBC monkey patch there has been no version 5 support), I have managed to find a working, and critically viable, solution for using MySQL 5 with XMPie uProduce.

cherrycitysoftware.com sell (not that you can even call it that, its only $10) a little mysql driver that with a little bit of work you can make work with uProduce and uPlan - its nice to have MySQL back!

You can use a DSN with generic DB like this:

<code>Provider=OleMySql.MySqlSource.1;Password=YOURPASSWORD;Persist 
SecurityInfo=True;User ID=YOURUSERNAME;Data Source=YOURDBHOST;
Location=YOURDBHOST;Mode=Read;Trace="";Initial Catalog=INITIALDATABASE</code>

Initial results are great - its working cleanly and quickly - good times with MySQL!

blog comments powered by Disqus