I just had this problem using ODBC 3.51 and I solved it by converting BIGINT
data types to INT. I had the flag in the ODBC data source set to convert
BIGINT to INT but that didn't seem to correct the issue.
From: Rigov [mailto:imlistening@stripped]
Sent: Friday, February 03, 2006 9:39 AM
Subject: #deleted in Access
I have MySQL 3.21.x and MySQL Connector/ODBC 3.51 and for one of my tables,
all values show up as #Deleted. I've followed the directions found under
Support on mysql.com, but to no avail. I'm using Access 2003.
Here is a definition of the table:
CREATE TABLE `device_responses` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`time_tag` bigint(10) unsigned default NULL,
`system` enum('D') NOT NULL default 'STE',
`device` enum('A', 'B', 'C') NOT NULL default 'HEARTBEAT',
16','17','18','19','20','21','22','23') NOT NULL default '0',
`sender` enum('0','1','2','3','4','5','6','7','8') default '0',
`command` varchar(8) default NULL,
`response` varchar(8) default NULL,
PRIMARY KEY (`id`),
KEY `(command, response)` (`command`,`response`),
KEY `(response, command)` (`response`,`command`),
KEY `device` (`device`),
KEY `system` (`system`),
KEY `sender` (`sender`)
) TYPE=InnoDB AUTO_INCREMENT=1 ;
Other tables have similar properties, and they do not have this problem.
This is the only InnoDB table, but even after dropping it, and creating new
as MyISAM, I had no luck. Other tables have bigint() and they are okay.
Any help would be appreciated.
No banners. No pop-ups. No kidding.
Make My Way your home on the Web - http://www.myway.com
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=1