Solved

Visual Basic RDO Connection MySQL Error 429

Posted on 2004-08-03
2
1,090 Views
Last Modified: 2013-12-25
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.

Thank you,


0
Comment
Question by:nkjohnson
2 Comments
 
LVL 29

Accepted Solution

by:
leonstryker earned 500 total points
ID: 11704996
Can you create an OBDC DSN to MySQL from the Start/Settings/Control Panel/Data Sources (ODBC)?

This would act as a test to see if your dll is registered correctly.

BTW, why are you using RDO?  It is an outdated technology.

Leon
0
 

Author Comment

by:nkjohnson
ID: 11705709
The ODBC connection is fine.  You are correct RDO is outdated, and I am currently looking into ADO.  I have actually already created a connection that does not have a problem.

Thanks for your help.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
vba find the last empty column 10 89
Excel object stays open 19 71
SQL VB connection works in one PC and doesn't in another 15 58
Problem to With line 4 43
Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now