MySQL Forums
Forum List  »  Connector/ODBC

How to connect MySQL 5.x from VB6.0 using OLEDB
Posted by: g dhanasekaran
Date: June 15, 2009 06:37AM

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: "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

Options: ReplyQuote

Written By
How to connect MySQL 5.x from VB6.0 using OLEDB
June 15, 2009 06:37AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.