MySQL Forums
Forum List  »  Connector/ODBC

Starting off with MySql ODBC
Posted by: PK Odendaal
Date: June 28, 2018 10:58PM

I am developing with VB6 (DAO or ADO) and converting to MySql.
I downloaded the Connector/ODBC 8.0.11 and used the msi install.
As I understand it, I must include a reference to that connector in my project, but I do not find the connector under my available references. If I need to browse for it, I do not know what I will be searching for and where. I presume the api was registered when I installed it

I use this construct to open my database, but it gives me the error: ODBC call failed.

Set conn = ws.OpenConnection("ibsmsmariafreestate", dbDriverNoPrompt, False, "odbc;DRIVER={MySQL ODBC 5.2 driver";SERVER=localhost;DATABASE=ibsmsmariafreestate;")

Is there perhaps a tutorial that I can use to go through this drama and pain.

Options: ReplyQuote


Subject
Written By
Posted
Starting off with MySql ODBC
June 28, 2018 10:58PM


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.