Here is the table structure.
In this case I tried to change the 4 characters in prod_ID when I get the
message, but I get the same message when I try to make any changes.
Doing the exact same activity works fine on all of the 3.23/4.0/4.1 versions
I have installed previouly. Tables with unsigned integer fields work just
fine through this interface on previous versions. The only anomaly up to
this point is that I can't change timestamp fields through the odbc
connection. They display as dates in access and I can change other fields in
the table correctly, just can't change the timestamp fields.
mysql> show create table product_order_choice;
---------------------------+
| Table | Create Table
|
---------------------------+
| product_order_choice | CREATE TABLE `product_order_choice` (
`cpny_ID` varchar(4) NOT NULL default '',
`prod_ID` varchar(4) NOT NULL default '',
`porc_Look_Up_Type` varchar(25) NOT NULL default '',
`prft_Sub_Month` char(2) NOT NULL default '00',
`prft_Sub_Item` char(2) NOT NULL default '0',
`poch_Name` varchar(100) NOT NULL default '',
`prct_ID` varchar(4) default NULL,
`poch_Value` text,
`poch_Image_Path` varchar(255) default NULL,
`poch_Link` varchar(255) default NULL,
`poch_Link_2` varchar(255) default NULL,
`poch_Active` enum('Yes','No','Hidden') NOT NULL default 'Yes',
`poch_Timestamp` timestamp(14) NOT NULL,
`poch_Create` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY
(`cpny_ID`,`prod_ID`,`porc_Look_Up_Type`,`prft_Sub_Month`,`prft_Sub_Item`,`p
och_Name`)
) TYPE=InnoDB |
---------------------------+
1 row in set (0.00 sec)
mysql>
-----Original Message-----
From: Daniel Kasak [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 04, 2005 5:16 PM
To: Gordon; 'MySQL'
Subject: Re: ACCESS ODBC Interface whit 5.0.4
Gordon wrote:
>I have been using ACCESS to do simpe data editing on our MySQL tables for 3
>years.
>
>
>
>I recently installed 5.0.4 on my machine to evaluate it. I linked the
tables
>into ACCESS through my old ODBC driver and got
>
>
>
>ODBC-update on a linked table 'product_order_choice' failed
>
>[Microsoft][ODBC Driver Manager] SQL data type out of rance (#0)
>
>
>
>I then downloaded and installed the current ODBC connector [3.51.11]
>thinking maybe it was my old ODBC copy, but get the same result.
>
>
>
>Has anyone else seen this or have any ideas?
>
>
>
>
It would help if you posted details of the table / data you're working with.
'Data type out of range' usually means you've tried to put a numerical
value in a field which is too small. For example, you may be trying to
put an int value in a mediumint field. Or it could be that you're using
a field type not supported by MS Access, such as an unsigned int or a
bigint.
--
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: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
