Recommended Servers for MySQLThe world's most popular open source database
MySQL Forums
MySQL and VS2008 problems with Time/TimeSpan and DateTime
Posted by: Harsh W ()
Date: November 06, 2009 09:08PM
I'm using MySQL 5.1.39 x64 on Windows and Visual Studio 2008. I have a couple of problems, just want to know if anyone has seen something like this before ...
Using connector/net versions 5.2.7, 6.1.2, 6.2.0 and adding a dataset to Visual Studio - I get the dreaded " Failed to add relations : Column 'REFERENCED_TABLE_CATALOG' does not belong to table... ". It adds the tables but not the relationships ... I wonder what is going on. Tried recreating database from scripts, no luck so far. Has anyone come across this problem and if they solved it, care to share the wisdom ?
The other problem is that one of the tables uses TIME and DATETIME columns. The TableAdapter created from the typed dataset for the TIME column maps to a System.DateTime ... shouldn't it map to a System.TimeSpan ? Anyone know of how to get the VS2008 integration to handle TIME mappings correctly ?
Using connector/net versions 5.2.7, 6.1.2, 6.2.0 and adding a dataset to Visual Studio - I get the dreaded " Failed to add relations : Column 'REFERENCED_TABLE_CATALOG' does not belong to table... ". It adds the tables but not the relationships ... I wonder what is going on. Tried recreating database from scripts, no luck so far. Has anyone come across this problem and if they solved it, care to share the wisdom ?
The other problem is that one of the tables uses TIME and DATETIME columns. The TableAdapter created from the typed dataset for the TIME column maps to a System.DateTime ... shouldn't it map to a System.TimeSpan ? Anyone know of how to get the VS2008 integration to handle TIME mappings correctly ?
| Subject | Written By | Posted |
|---|---|---|
| MySQL and VS2008 problems with Time/TimeSpan and DateTime | Harsh W | 11/06/2009 09:08PM |
Sorry, only registered users may post in this forum.