Very Computer

by **Brando** » Sat, 30 Jun 2001 06:25:39

OK, here's a problem that has stumped me as well as others
in my dev. team for days now...

I create a simple UserControl (VB 6.0) that makes
referrence to "Microsoft ActiveX Data Objects 2.5" and
uses the ADODB.Command object to communicate with a SQL
database. The code works fine on my machine but on all
the other machines out on the employee floor they get the
following error:

Error Code: 429
Error: ActiveX component can't create object.

The ActiveX control is being loaded into a web browser,
(getting error on all versions of IE above 5, havent tried
on lower versions as none of available) via the <object>
tag, which follows:

The CAB file was created with the Package and Deployment
wizard, all required files were set to be included in the
cab (makes the download faster since they are then
downloaded right from our servers instead of microsoft).

After creating the CAB I digitally signed it with the
newest version of the signcode utility.

The error occurs on the line in the code which starts to
use the Command object, that segment of code follows:

Dim cmdMain As New ADODB.Command
cmdMain.CommandType = adCmdStoredProc <-----

the line with the <----- is the line that SEEMS to be
producing the error.

Any thoughts as to why this is happening would be
appreciated.

Thanks,
Brandon

by **Steve Parke** » Sun, 01 Jul 2001 02:04:48

The clients on the shop floor have MDAC2.5 installed?

Quote:> OK, here's a problem that has stumped me as well as others
> in my dev. team for days now...

> I create a simple UserControl (VB 6.0) that makes
> referrence to "Microsoft ActiveX Data Objects 2.5" and
> uses the ADODB.Command object to communicate with a SQL
> database. The code works fine on my machine but on all
> the other machines out on the employee floor they get the
> following error:

> Error Code: 429
> Error: ActiveX component can't create object.

> The ActiveX control is being loaded into a web browser,
> (getting error on all versions of IE above 5, havent tried
> on lower versions as none of available) via the <object>
> tag, which follows:

> <OBJECT classid="CLSID:98F8CE10-6C06-11D5-A335-
> 0008C74526E9"
> codebase="EmployeeAdmin.CAB#version=1,0,0,22" id=uctrlMain
> style="LEFT: 0px; TOP: 0px" VIEWASTEXT>
> <PARAM NAME="_ExtentX" VALUE="15875">
> <PARAM NAME="_ExtentY" VALUE="11959">
> </OBJECT>

> The CAB file was created with the Package and Deployment
> wizard, all required files were set to be included in the
> cab (makes the download faster since they are then
> downloaded right from our servers instead of microsoft).

> After creating the CAB I digitally signed it with the
> newest version of the signcode utility.

> The error occurs on the line in the code which starts to
> use the Command object, that segment of code follows:

> Dim cmdMain As New ADODB.Command
> cmdMain.CommandType = adCmdStoredProc <-----

> the line with the <----- is the line that SEEMS to be
> producing the error.

> Any thoughts as to why this is happening would be
> appreciated.

> Thanks,
> Brandon

by **Brando** » Sun, 01 Jul 2001 04:25:24

Thanks for the reply,
No, most of the employees don't have it installed. Am I
not correct in assuming that the .cab file should install
mdac for them? I know that msado15.dll (which shows up as
Microsoft ActiveX Data Objects 2.6 in VB) IS included in
the cab.

Thanks in advance (again),
Brandon

>-----Original Message-----
>The clients on the shop floor have MDAC2.5 installed?

>> OK, here's a problem that has stumped me as well as
others
>> in my dev. team for days now...

>> I create a simple UserControl (VB 6.0) that makes
>> referrence to "Microsoft ActiveX Data Objects 2.5" and
>> uses the ADODB.Command object to communicate with a SQL
>> database. The code works fine on my machine but on all
>> the other machines out on the employee floor they get
the
>> following error:

>> Error Code: 429
>> Error: ActiveX component can't create object.

>> The ActiveX control is being loaded into a web browser,
>> (getting error on all versions of IE above 5, havent
tried
>> on lower versions as none of available) via the <object>
>> tag, which follows:

>> <OBJECT classid="CLSID:98F8CE10-6C06-11D5-A335-
>> 0008C74526E9"
>> codebase="EmployeeAdmin.CAB#version=1,0,0,22"
id=uctrlMain
>> style="LEFT: 0px; TOP: 0px" VIEWASTEXT>
>> <PARAM NAME="_ExtentX" VALUE="15875">
>> <PARAM NAME="_ExtentY" VALUE="11959">
>> </OBJECT>

>> The CAB file was created with the Package and Deployment
>> wizard, all required files were set to be included in
the
>> cab (makes the download faster since they are then
>> downloaded right from our servers instead of microsoft).

>> After creating the CAB I digitally signed it with the
>> newest version of the signcode utility.

>> The error occurs on the line in the code which starts to
>> use the Command object, that segment of code follows:

>> Dim cmdMain As New ADODB.Command
>> cmdMain.CommandType = adCmdStoredProc <-----

>> the line with the <----- is the line that SEEMS to be
>> producing the error.

>> Any thoughts as to why this is happening would be
>> appreciated.

>> Thanks,
>> Brandon

>.

by **Brando** » Sun, 01 Jul 2001 04:37:50

Oh yeah, BTW, I made referrence to Mdac 2.5 in my first
post, and 2.6 in my second, just to clear things up I have
tried BOTH, and both give me the 429 error, (ActiveX
component can't create object).

Thats All =)
Brandon