OLEDB Driver for MySQL


Author
Message
Keith Chisarik
Keith Chisarik
StrataFrame VIP (2.4K reputation)StrataFrame VIP (2.4K reputation)StrataFrame VIP (2.4K reputation)StrataFrame VIP (2.4K reputation)StrataFrame VIP (2.4K reputation)StrataFrame VIP (2.4K reputation)StrataFrame VIP (2.4K reputation)StrataFrame VIP (2.4K reputation)StrataFrame VIP (2.4K reputation)
Group: StrataFrame Users
Posts: 939, Visits: 40K
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

Replies
Keith Chisarik
Keith Chisarik
StrataFrame VIP (2.4K reputation)StrataFrame VIP (2.4K reputation)StrataFrame VIP (2.4K reputation)StrataFrame VIP (2.4K reputation)StrataFrame VIP (2.4K reputation)StrataFrame VIP (2.4K reputation)StrataFrame VIP (2.4K reputation)StrataFrame VIP (2.4K reputation)StrataFrame VIP (2.4K reputation)
Group: StrataFrame Users
Posts: 939, Visits: 40K
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

Keith Chisarik

Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
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.

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search