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

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/myodbc?unsub=gcdmo-myodbc@m.gmane.org

RE: Visio Reverse Engineer - Character Set

> -----Original Message-----
> From: Mont McAdam [mailto:mont@platformnetworks.net]
> Sent: Wednesday, January 23, 2008 9: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˜œ±«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.
[JS] Version 3.51 of the ODBC connector does not handle UTF8 characters. Try
version 5.x.




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