Problems with DATE types in Access using myodbc
Hi All,
I have a MySQL4.1 table with a DATE data type. When I link the table
in Access using myobdb 3.51, Access incorrectly sees the data type as a
text type.
I tried changing the data type to TIME, TIMESTAMP, or DATETIME, but I
always get a text type in Access. The result is that inserts and
updates all fail. I can't figure out how to update! If I format the
string the way mysql wants it, I get an ODBC error: "SQL data type out
of range (#0)"
I updated MDAC to 2.8, updated MS Jet. no change.
I tried myodbc 3.51.11, still no luck. This all worked with myodbc
2.50, but I had too many other problems with 2.50
Has anyone had this problem or know a work-around?
Thanks for the help!
Denis.
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org
Re: Problems with DATE types in Access using myodbc
denis.gallagher [at] merek.ca wrote:
>Hi All,
>
>I have a MySQL4.1 table with a DATE data type. When I link the table
>in Access using myobdb 3.51, Access incorrectly sees the data type as a
>text type.
>
>I tried changing the data type to TIME, TIMESTAMP, or DATETIME, but I
>always get a text type in Access. The result is that inserts and
>updates all fail. I can't figure out how to update! If I format the
>string the way mysql wants it, I get an ODBC error: "SQL data type out
>of range (#0)"
>
>I updated MDAC to 2.8, updated MS Jet. no change.
>I tried myodbc 3.51.11, still no luck. This all worked with myodbc
>2.50, but I had too many other problems with 2.50
>
>Has anyone had this problem or know a work-around?
>
>Thanks for the help!
>
>Denis.
>
>
>
>
You can monitor the progress at:
http://bugs.mysql.com/?id=8363
You should be able to use MyODBC-3.51.09.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak [at] nusconsulting.com.au
website: http://www.nusconsulting.com.au
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org
