VB6 Classic - Mysql Characters Error

Job ID: 33422085

Budget: $10 – $30 USD

I need a simple code to connect to mysql from VB6 (Only the connection and retriving information). I am using the code in the attachment and the driver attachment too, but have problems with some characters, specially "ñ". I try a lot of codes but don´t work. Using Navicat to connect show correct the characters, but from VB6 no.
Related categories: PHP XML Visual Basic Software Architecture MySQL