Hello, in my Vb6 application i retrieve data from MySQL.
Recently i installed the application on Windows 7 machine and i get strange chars in datagrid from database. It only occurs on columns where i use CONCAT and SUBSTRING functions.

Name:  1.jpg
Views: 191
Size:  8.7 KB

Connection is made with :

Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset

Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset

conn.Open "DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=database;UID=user;PWD=pass; OPTION=3"
On windows xp it's running ok.

Thank you!