|
| | | 
Advanced StrataFrame User
 
Group: StrataFrame Users
Last Login: Today @ 7:20:31 PM
Posts: 666, Visits: 27,922 |
| | 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. |
| |
| | |
Advanced StrataFrame User
Group: StrataFrame Users
Last Login: Today @ 7:20:31 PM
Posts: 666, Visits: 27,922 |
| screenshot showing error after selecting a table
|
| |
| | |
Advanced StrataFrame User
Group: StrataFrame Users
Last Login: Today @ 7:20:31 PM
Posts: 666, Visits: 27,922 |
| | 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? |
| |
| | | Advanced StrataFrame User
Group: StrataFrame Users
Last Login: Today @ 7:53:31 PM
Posts: 760, Visits: 3,283 |
| | |
| | |
Advanced StrataFrame User
Group: StrataFrame Users
Last Login: Today @ 7:20:31 PM
Posts: 666, Visits: 27,922 |
| | I am using the OLEDB provider Trent says should work in that first post. Still hoping.... |
| |
| | |
Advanced StrataFrame User
Group: StrataFrame Users
Last Login: Today @ 7:20:31 PM
Posts: 666, Visits: 27,922 |
| | 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  |
| |
| | | 
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Today @ 6:26:12 PM
Posts: 4,901, Visits: 4,887 |
| | 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 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. |
| |
| | |
Advanced StrataFrame User
Group: StrataFrame Users
Last Login: Today @ 7:20:31 PM
Posts: 666, Visits: 27,922 |
| | 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. |
| |
| | |
Advanced StrataFrame User
Group: StrataFrame Users
Last Login: Today @ 7:20:31 PM
Posts: 666, Visits: 27,922 |
| | 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. |
| |
|
|