us

[JRough]

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,

 

[Barb Way]

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.

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.

Barb Way
Product Support - Visio
Microsoft Corporation
[This posting is provided "As Is" with no warranties, and confers no
rights.]
--------------------

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,