Re: Visio Reverse Engineer - Character Set

Dear Mont,


Are you able to get this information using some other tool, such as
WinSQL? I recommend using WinSQL to see if you can reverse engineer the
schema. This test will proof if the problem is on the server end,
network connectivity or the client.

Another suggestion is to turn on ODBC tracing to see which method in the
ODBC API is actually creating problem.

Regards,
Imran.


Mont McAdam wrote:
> 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???椴B'.
> Error! Cannot extract column definition for the table/view 'a???椴B'.  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=utf8_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/[email protected]