How to connect MySQL 5.x from VB6.0 using OLEDB

[g dhanasekaran]

Hi all,

I am new to using MySQL5.1. As of my task, I need to connect my remote MySQL database from Visual Basic 6.0 using OLEDB connector.

I have got a tool from Web as trial version. I can't get any free version of OLEDB connector for this purpose.

Also I want to execute rs.update method of VB6.0. When I am using this i got an runtime error as

"Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done."

connection string is:
objCon.open "Provider=OleMySql.MySqlSource.1; Data Source=localhost,3306; Initial Catalog=ATandT", "root", ""

So my questions are:

1. Is any problem with the provider (trial version)?

2. Will the MySQL5.1 accept the rs.Update method?

3. Is my connection string right or not?

Please help me to solve the issues.

Thanks in advance.

Dhanasekaran. G