Visual Basic RDO Connection MySQL Error 429
Posted on 2004-08-03
I am currently trying to access a MySQL database in a VB6 app. I have installed MySQL ODBC Driver 3.51 and created an ODBC linking to the table. The code below is the code that is generating the error.
Dim cnMySql as new rdoConnection
cnMySql.CursorDriver = rdUseOdbc
I get an error when I try to call the cnMySQL object (error below)
Run-Time error '429'
ActiveX Component can't create object.
I thought that this may be a registration problem. So I ran regsrv32 c:\winnt\system32\myodbc3.dll
I get the following message.
c:\winnt\system32\myodbc3.dll was loaded but the DllRegisterServer entry point was not found. DllRegisterServer may be exported, or a corrupt version of myodbc3.dll may be in memory. Consider using PVIEW to detect and remove it.
I am new to dll registration so I don't know if this file does not need to be registered or if maybe something is wrong with the dll.