Automation Error 430

[Gretchen S.]

I'm not sure why this error is occuring. The Help files suggests I have not
exposed a programmability interface. The structure of my program is as follows:
Class Module 1 - Contains variable declarations and property procedures.
Class Module 2 - Retrieves data from SQL7 tables and assigns values to the
variables in Class Module 1. It then writes those values to a text file.
Form - there is only one form. there is a button which calls the Sub in
class Module 2 and passes a date specified by the user via a datepicker.
I'm using VB6. My computer is an NT4.0 workstation. When I run the program
on my computer it works perfectly, but throws the automation error when installed
and run from my user's computer. I get the same error whether it is installed
on an NT 4.0 workstation or Windows 98. The error occurs after the button
on the form has been clicked.
Can anyone point me in the right direction for finding the solution to this
problem?
Thank you,
Gretchen

[ian drake]

Gretchen

Automation errors are usually from some sort of problem with a COM object.
It seems to me that you might have a dependancy problem. Did you make an
installation package? What method did you use for data access RDO, ADO ?


Ian


"Gretchen S." <cmonster25@hotmail.com> wrote:
>
>I'm not sure why this error is occuring. The Help files suggests I have
not
>exposed a programmability interface. The structure of my program is as
follows:
>Class Module 1 - Contains variable declarations and property procedures.
>Class Module 2 - Retrieves data from SQL7 tables and assigns values to the
>variables in Class Module 1. It then writes those values to a text file.
>Form - there is only one form. there is a button which calls the Sub in
>class Module 2 and passes a date specified by the user via a datepicker.
>I'm using VB6. My computer is an NT4.0 workstation. When I run the program
>on my computer it works perfectly, but throws the automation error when
installed
>and run from my user's computer. I get the same error whether it is installed
>on an NT 4.0 workstation or Windows 98. The error occurs after the button
>on the form has been clicked.
>Can anyone point me in the right direction for finding the solution to this
>problem?
>Thank you,
>Gretchen

[Gretchen S.]

I did make an installation package. I used ADO to access the data.
Gretchen

"ian drake" <ian.drake1@home.com> wrote:
>
>Gretchen
>
>Automation errors are usually from some sort of problem with a COM object.
> It seems to me that you might have a dependancy problem. Did you make
an
>installation package? What method did you use for data access RDO, ADO
?
>
>
>Ian
>
>
>"Gretchen S." <cmonster25@hotmail.com> wrote:
>>
>>I'm not sure why this error is occuring. The Help files suggests I have
>not
>>exposed a programmability interface. The structure of my program is as
>follows:
>>Class Module 1 - Contains variable declarations and property procedures.
>>Class Module 2 - Retrieves data from SQL7 tables and assigns values to
the
>>variables in Class Module 1. It then writes those values to a text file.
>>Form - there is only one form. there is a button which calls the Sub in
>>class Module 2 and passes a date specified by the user via a datepicker.
>>I'm using VB6. My computer is an NT4.0 workstation. When I run the program
>>on my computer it works perfectly, but throws the automation error when
>installed
>>and run from my user's computer. I get the same error whether it is installed
>>on an NT 4.0 workstation or Windows 98. The error occurs after the button
>>on the form has been clicked.
>>Can anyone point me in the right direction for finding the solution to
this
>>problem?
>>Thank you,
>>Gretchen
>

[Gretchen S. cmonster25]

Could the problem be that my class properties are not set correctly? What
should they be for each class module?

[ian drake]

You must be using somthing Active X? What type of project(s) do you have
for this program. It sound like you are having a registry problem with COM.
There must be at least one Project in your program that is Active X. If
you are not coding anything into an active X exe or dll I have NO idea what
the couse might be.

Ian

[Matt Brook]

Hello Gretchen,

One thing you may want to check is that the same MDAC is installed on both
computers. I have gotten this error before, when my developing computer
had MDAC 2.5 and mu production computer was only running MDAC 2.0.

Just a suggestion,
Matt

"Gretchen S." <cmonster25@hotmail.com> wrote:
>
>I'm not sure why this error is occuring. The Help files suggests I have
not
>exposed a programmability interface. The structure of my program is as
follows:
>Class Module 1 - Contains variable declarations and property procedures.
>Class Module 2 - Retrieves data from SQL7 tables and assigns values to the
>variables in Class Module 1. It then writes those values to a text file.
>Form - there is only one form. there is a button which calls the Sub in
>class Module 2 and passes a date specified by the user via a datepicker.
>I'm using VB6. My computer is an NT4.0 workstation. When I run the program
>on my computer it works perfectly, but throws the automation error when
installed
>and run from my user's computer. I get the same error whether it is installed
>on an NT 4.0 workstation or Windows 98. The error occurs after the button
>on the form has been clicked.
>Can anyone point me in the right direction for finding the solution to this
>problem?
>Thank you,
>Gretchen

[Gretchen S.]

Hi Matt,
Thanks for your suggestion. In my installation package, MDAC 2.0 is installed
on the user machines. I believe I am running 2.0 as well, but am not sure
how to check. At any rate, I installed 2.0 on my machine. I'm still having
the same problem. When I created my install package I had an out of date
dependency file: mscomctl.ocx. I took the controls off my form that required
the reference to this component, recompiled and created a new exe, it didn't
solve my problem. Next I installed Visual Studio on a computer that my program
would not work on. Once VB was installed it worked correctly! There is
some component installed with VB that needs to be installed on the users
computers, but I don't know what that component is. I uninstalled VB on
from that computer, hoping it would leave behind the magical component, but
no luck. Once I uninstalled VB, my program no longer worked. Any ideas,
suggestions?
Gretchen

[Ronald Dolman]

Gretchen,


> I believe I am running 2.0 as well, but am not sure how to check.

To check the ADO version create a new project, set a reference to MDAC,
create a module and type:

Sub Main
Dim oConn As New Connection
MsgBox oConn.Version
End Sub

Beware, the Connection Version property will always display the highest
(installed) version number on your system.

BTW Are you shure you included ADO (MDAC) in your installation package?
Unlike the case with DAO, the ADO (MDAC) files are bu default not in the
installation package.

Ronald

[rt]

>I did make an installation package. I used ADO to access the data.

What installation package are you using? I have had a lot of ActiveX registration
problems with the VB Package and Deploy wizard, but since I moved to the
Visual Studio Installer 1.1 I eliminated them completely.

[mrfelis]

This could also be caused by compatibility and/or versioning of any custom
Active X components. Do you have any of these?

Not that I wanted to open this can of worms!

--
~~~
C'Ya,
mrfelis
mrfelis@yahoo.NOSPAM.com
just remove the spam
Gretchen S. <cmonster25@hotmail.com> wrote in message
news:39f85993@news.devx.com...
>
> I'm not sure why this error is occuring. The Help files suggests I have
not
> exposed a programmability interface. The structure of my program is as
follows:
> Class Module 1 - Contains variable declarations and property procedures.
> Class Module 2 - Retrieves data from SQL7 tables and assigns values to the
> variables in Class Module 1. It then writes those values to a text file.
> Form - there is only one form. there is a button which calls the Sub in
> class Module 2 and passes a date specified by the user via a datepicker.
> I'm using VB6. My computer is an NT4.0 workstation. When I run the
program
> on my computer it works perfectly, but throws the automation error when
installed
> and run from my user's computer. I get the same error whether it is
installed
> on an NT 4.0 workstation or Windows 98. The error occurs after the button
> on the form has been clicked.
> Can anyone point me in the right direction for finding the solution to
this
> problem?
> Thank you,
> Gretchen