Visio Reverse Engineer - Character Set

Some more info I have just thought to provide is that MySQL server is on
remote linux machine, not local on windows box.


-----Original Message-----
From: Mont McAdam=20
Sent: Thursday, 24 January 2008 1:00 PM
To: 'myodbc@lists.mysql.com'
Subject: Visio Reverse Engineer - Character Set

Hey all,

I have just installed the ODBC connector version 3.51 into Windows Vista

I am trying to use reverse engineer through Visio 2007, but having an =
odd
problem.

Essentially in the import wizard it is showing me the tables from the =
target
database in what appear to be asian characters of some sort, but the =
first
character of every table name is the correct character. Import =
completely
fails with error:

-------------------------------------

Extracting columns of table 'a˜œ±=ABB'.
Error! Cannot extract column definition for the table/view =
'a˜œ±=ABB'. The
definition is not available or you may not have sufficient privileges.
Please check with your database administrator.

-------------------------------------

I have manually set the character type on that table which real name is
"accounts" to utf8 collation=3Dutf8_general_ci and set the default =
character
set in ODBC DSN to utf8.

Any thoughts? Or idead on how I might debug...

Thanks in advance
Mont

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg