List:MySQL ODBC« Previous MessageNext Message »
From:Vic Spainhower Date:February 3 2006 9:29pm
Subject:RE: #deleted in Access
View as plain text  
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.

Vic 

-----Original Message-----
From: Rigov [mailto:imlistening@stripped] 
Sent: Friday, February 03, 2006 9:39 AM
To: myodbc@stripped
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',
  `subunit`
enum('0','1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','
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.

Thanks


_______________________________________________
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

Thread
#deleted in AccessRigov3 Feb
  • RE: #deleted in AccessMartin J. Evans3 Feb
    • RE: #deleted in AccessMartin King-Turner3 Feb
  • RE: #deleted in AccessVic Spainhower3 Feb
RE: #deleted in AccessRon Alexander3 Feb