Skip navigation links

MySQL Forums :: Connector/ODBC :: How to connect MySQL 5.x from VB6.0 using OLEDB


Advanced Search

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

Options: ReplyQuote


Subject Written By Posted
How to connect MySQL 5.x from VB6.0 using OLEDB g dhanasekaran 06/15/2009 06:37AM
Re: How to connect MySQL 5.x from VB6.0 using OLEDB Jay Alverson 06/17/2009 01:08PM
Re: How to connect MySQL 5.x from VB6.0 using OLEDB g dhanasekaran 06/19/2009 11:19PM


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.