Small project. I'm OK with the limitations of OLE.

Two drivers for MySQL that work fine in VS2008 don't in the BO Mapper and I am looking for some help.

They both do the same thing. They connect to the database, enumerate the tables, but blow out trying to enumerate the fields. I cant copy the text of the error message from the Mapper (feature request) so I will type it out below. I know I should use SQL Server but the customer has MySQL and it does work in "straight" Visual Studio so I am hopeful you have an idea for a fix.

I can provide a connection string if desired as the server is public.

Error: The fields could not be displayed. The requested collection (indexes) is not defined.

If you need the trace, let me know.

Keith Chisarik

This is the same behavior DB2 used to get with OLE before you fixed it (connected, table emumeration fine, field enumeration issue), perhaps you can tell me when you did there and I can try a fix if you think they are related.

Aside: If I need to get around this fast, can I create a copy of the table in SQL Server, use that to "map" and then populate via the OLE driver?

Keith Chisarik

Hi Keith,

News are not good, check these posting:

http://forum.strataframe.net/Topic14925-6-1.aspx?Highlight=mysql

http://forum.strataframe.net/Topic9658-9-1.aspx?Highlight=mysql

P.S.

Just for the record, I would also like to see MySQL support in SF.  Hosting services for MySQL are much more cheeper than SQL 2005 with bigger DB space.

Edhy Rijo