MySQL Forums
Forum List  »  Microsoft Access

Re: ODBC - insert on a linked field - [microsoft][ODBC Driver Manager] SQL data type out
Posted by: dhs
Date: May 27, 2005 11:36AM

Rein van der Mast wrote:
> Installing the latest version of MyODBC (after
> removing the previous one) togehter with removing
> all 'unsigned' values from MySQL did the job for
> me.
>
> R.

DateTime types do not have a signed/unsigned attribute.

The problem is still that Access linked tables see MySQL DateTime as a Text(255), and even if you format the data as yyyy-mm-dd you will get the ODBC insert error.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: ODBC - insert on a linked field - [microsoft][ODBC Driver Manager] SQL data type out
2594
dhs
May 27, 2005 11:36AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.