StrataFrame Forum

OLEDB Driver for MySQL

http://forum.strataframe.net/Topic18319.aspx

By Keith Chisarik - 8/4/2008

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.

By Keith Chisarik - 8/4/2008

screenshot showing error after selecting a table
By Keith Chisarik - 8/4/2008

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?

By Edhy Rijo - 8/4/2008

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.

By Keith Chisarik - 8/4/2008

I am using the OLEDB provider Trent says should work in that first post. Still hoping....
By Keith Chisarik - 8/4/2008

Well I should say I think Im using it. There are a number of them out there, perhaps I am not using THE right OLEBD provider for MySQL. If you SF guys have one that you know works (sounds like you do from the post Edhy provided), please point me there.

Someday..... SQL Server only Smile

By Trent L. Taylor - 8/5/2008

This is going to just have to be something that we setup and test.  It looks as though the GetSchema is returning different specs than that of the standard GetSchema specs....which I think that we have been here before Smile

Shoot me an email with the OLEDB provider you are using and if you have a server already setup and exposed, maybe that information as well...otherwise we will just download a copy and load one here.  You may have to give us a few days on this as we have a lot on our plate this week.  Thanks.

By Keith Chisarik - 8/5/2008

I am happy to do that, but also 110% willing to change to an OLEDB provider that you know to work with the mapper as per your other post.

Yes, we have been here before. I wish I was SQL only, trust me.

By Keith Chisarik - 8/5/2008

Trent, dont worry about this for now.

The tables were small so I recreated them on SQL Server to map the BO's and I have a MySQLDataSource about 2/3 done, inserts and selects are working so I just have to do updates. If you have a quick fix to tget the BO Mapper happy then great, otherwise I have a workaround.