MySQL Forums :: Connector/ODBC :: How to connect MySQL 5.x from VB6.0 using OLEDB
How to connect MySQL 5.x from VB6.0 using OLEDB
Posted by: g dhanasekaran
Date: June 15, 2009 06:37AM
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.
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.