Runtime error '430'

Runtime error '430'

Post by U3RldmV » Fri, 08 Apr 2005 23:19:08

I installed 'MSDE2000A' Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)
Release A (October 13, 2003)
This was not required so I uninstalled it and removed the folder C:\Program
Files\Microsoft SQL Server\MSSQL

Then I installed an older version 'MSDE2000SP3' Service Pack 3 for Microsoft
SQL Server 2000 (December 9, 2002)

Now I cannot use this 'older' version anymore. I get the error message
"Runtime error '430': Class does not support Automation or does not support
expected interface"
According to this error, Visual Basic preserves the Class ID (CLSID) of a
class which ends up being registered with two servers; the in-proc server
(DLL) and the local server (EXE).
With the creation of an instance of the class from a client, the class from
the DLL is chosen. Because the class from the DLL does not support the new
IID, the above error occurs.

So the resolution is that I need to use the RegSvr32.EXE utility to
unregister the old DLL server and re- register the new EXE server to
eliminate this error.

But which is the old DLL and what is the new EXE server? Can somebody help
me with this?


1. Runtime error 430

2. Still problems with "Runtime Error 430" - checked correct MDAC

Hello again.

A summary of my earlier question follows:

I have several users that run my program but for some the following message

"Class does not support Automation or does not support expected

I'm aware that it can be difficult to say something about a program you
never have seen, but it is princply a simple program for transferring data
from AS400 to Access and at the same time convert some formats. I only use
textfields, lables and commandbutton. No ActiveX components.

The error starts in connection with this code:

Dim cnMovex As ADODB.Connection, rsSource As ADODB.Recordset, rsDest As
Set cnMovex = New ADODB.Connection
cnMovex.Open "Provider = MSDASQL.1;User ID=***;Password=***;Persist Security
Info=True;Data Source=AS400 analyser;Mode=Read;Initial Catalog=JMNORGE"

The user has all ODBC connections OK.
What happens and what can I do ?

Answer given:
Try installing the correct version of MDAC see if that solves the issue.
Jan Hyde (VB MVP)

I have checked my MDAC version against the users and the MDAC version is the
same (MDAC 2.8 SP1 on Windows XP SP2).
What else can be wrong ?

Roger A. Olavsen

3. Runtime Error 430

4. runtime error 430

5. Runtime error 430 from RegExp

6. Runtime Error : 430,

7. Runtime Error 430 (Class does not ...)

8. Win 98: VB Runtime error 430

9. runtime error 430

10. Runtime Error: 430

11. Runtime error 430

12. Runtime Error 430 Help Requested For Win XP SP2

13. Runtime Error 430

14. Runtime Error 430: Class does not support Automation...

15. runtime error 430