replacing/updating scrrun.dll.. how? 1

[StormbringerX]

Win2K, VB6, SQL2000

Hi all,

I'm attempting to deploy a VB package to a 'new' Win2k machine ('new' meaning that it only has the OS, no other software has been installed). I've created a setup package using Inno and the installation proceeds without any problems.

However, I'm having a problem with the following code (on the installation mahine only, it works fine on the development machine - as always):

Public Sub SPBalanceBusiness(ByVal strBusinessNo As String)
    Dim cmdStoredProc As ADODB.Command
    Set cmdStoredProc = New ADODB.Command
    Set cmdStoredProc.ActiveConnection = gcnProp
    With cmdStoredProc
        .commandText = "sp_BalanceBusiness"
        .CommandType = adCmdStoredProc
        .Parameters.Append .CreateParameter("@BusinessBegin", adChar, adParamInput, 6, strBusinessNo)
        .Execute
    End With
    Set cmdStoredProc = Nothing
End Sub

on the line: Set cmdStoredProc = New ADODB.Command

I receive Error Number:430, Class does not support Automation or class does not support expected interface.

I have researched this to the best of my ability, both here at Tek-Tips and at other sources, and I think the problem is with the scrrun.dll being out of date. The dll on the installation machine is older than the one on the development machine. However, I am having an impossible time removing the old dll and replacing it.

The steps I have taken are as follows:
1) unRegistering the scrrun.dll in the Winnt\system32 folder
2) Attempting to overwrite the scrrun.dll with the new version
3) Registering the new version.

It looks as though it's working fine, but when I check the date and size after doing this, the old dll is still there.

What I'm asking is, first of all, is is likely that the scrrun.dll is the source of my problem?
Second, what am I doing wrong to replace it?

Thanks for your time...

Dave

 

[MarkSweetland]

>> 'new' meaning that it only has the OS, no other software has been installed)

In addition to the OS on the target machine, you will also need to download and install the latest version of the Microsoft Data Access Components (MDAC) from the Microsoft website.


Mark

"You guys pair up in groups of three, then line up in a circle."
- Bill Peterson, a Florida State football coach

 

[StormbringerX]

Mark,
You hit that one right on the head! Thanks so much... a star for u.

Dave