In the visio.database archive there was a post on Visio Enterprise that you can use an ODBC driver to connect to MySQL in order to reverse engineer an ERD. This might solve my problem of connecting Visio Professional to all these Excel Sheets (separate tables) as datasources. Does anyone know if you can connect Visio Enterprise through an ODBC driver using MyPHPAdmin on a hosted database????? That may not be possible but I would like to know if anyone has tried it. What I would like to do is use my database hosted on MyHostingCompany's Server as a datasource through MyPHPAdmin. What is the difference between Visio Enterprise and Visio Professional? tia,
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fprq2\fcharset0 MS Sans Serif;}} \viewkind4\uc1\pard\f0\fs26 There really isn't an Enterprise version, the full name is Visio for Enterprise Architects - and that version is the one bundled with Visual Studio 2005 Team editions. Visio Professional has lower level versions of the Software (UML) and Database (ER and ORM) modeling solutions. In Visio for Enterprise Architects (VEA) you can Reverse Engineer and also generate databases, while in Visio Professional, you can only Reverse Engineer. Also VEA contains reporting for DB objects, but Pro does not. \par \par As to connecting to other databases through the ODBC Generic connector in Visio - it might work, if the database is a relational db based on Structured Query Language. If it maintains the structures in a separate worksheet like environment, then it probably won't. Note that we don't provide the ODBC driver - you have to have those installed already. Our connector (Visio Database Driver) then connects to your ODBC driver. \par \par Barb Way \par Product Support - Visio \par Microsoft Corporation \par [This posting is provided "As Is" with no warranties, and confers no rights.] \par \pard\li720 -------------------- \par \par In the visio.database archive there was a post on Visio Enterprise \par that you can use an ODBC driver to connect to MySQL in order to \par reverse engineer an ERD. This might solve my problem of connecting \par Visio Professional to all these Excel Sheets (separate tables) as \par datasources. Does anyone know if you can connect Visio Enterprise \par through an ODBC driver using MyPHPAdmin \par on a hosted database????? That may not be possible but I would like to \par know if anyone has tried it. What I would like to do is use my \par database hosted on MyHostingCompany's Server as a datasource through \par MyPHPAdmin. \par \par What is the difference between Visio Enterprise and Visio \par Professional? \par \par tia, \par \pard \par \par }
