MySQL Reverse Enginering

[NetRacer]

hi group,

i'm trying to model my MySQL-database (MySQL 5 running on Linux) with Visio
2003. the connection and data retrievement succeds. after finishing the
wizard, the tables are shown on paper but no relations (the complete db is
InnoDB with foreign key constraints). how can i get my relations, too?

thx for any help
NetRacer

 

[Anthony Bloesch]

My guess is the ODBC driver does not implement SQLForeignKeys. The database
solution is tolerant of a wide variety of ODBC driver bugs so it is unlikely
that the MySQL implementation of SQLForeignKeys has minor problems.

You could use ODBCTest to test out the driver and see if the SQLForeignKeys
function is working.

I assume you know that the database definately has foreign keys (an amazing
number of databases just do not have them).

Anthony

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Note: For the benefit of the community-at-large, all responses to this
message are best directed to the newsgroup/thread from which they
originated.

 

[NetRacer]

Yes, I'm sure... I created the db

look here:
"CREATE TABLE `tbl_ersatzteile` (
`E_ID` bigint(20) unsigned NOT NULL auto_increment,
`ENr` varchar(15) NOT NULL default '',
`Produkt_ID` bigint(20) unsigned NOT NULL default '0',
`EBez` varchar(150) NOT NULL default '',
`EPreis` double NOT NULL default '0',
`EMenge` tinyint(3) unsigned NOT NULL default '1',
`BG_ID` int(10) unsigned default NULL,
`Flag_Del` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`E_ID`),
KEY `Produkt_ID` (`Produkt_ID`),
KEY `BG_ID` (`BG_ID`),
CONSTRAINT `tbl_ersatzteile_ibfk_1` FOREIGN KEY (`Produkt_ID`) REFERENCES
`tbl_produkte` (`Produkt_ID`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `tbl_ersatzteile_ibfk_2` FOREIGN KEY (`BG_ID`) REFERENCES
`tbl_baugruppen` (`BG_ID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;"

where can I get ODBCTest ?!?

thx
NetRacer

 

[Anthony Bloesch]

It is likely to be the driver then. I assume you are running version 3.51
of the MyODBC driver. Here is a link
http://dev.mysql.com/doc/mysql/en/myodbc-trace.html to describe how to
enable ODBC tracing.

Anthony

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Note: For the benefit of the community-at-large, all responses to this
message are best directed to the newsgroup/thread from which they
originated.