ActiveX component can't create object

[robinsql]

Hi,

I have migrated a VB/Access app to VB/SQL 2000. The DB and the app reside on an NT server.
When I test the code on my local PC, it runs fine.
When I try and use the NT server, I receive the run-time error message '429'.
I have registered the DLL using regsvr32 from the command line.

This is the line of code in the project that calls the dll and gives the error.

Set m_oUtrac = New Utrac.cUTRACFile

Does anyone know what could be causing my problem?
Proving rather serious as I only discovered there was a problem when it went live!

Thanks for any help,

Robin

 

[WFadloun]

check your setup package.
go to referances , check all related libraries
insure that all of those libraries are included in your setup.
one of your library is missed.

regards

 

[robinsql]

Hi,

I have all the references. I have created an msi which includes the dll I wrote. It should be ok really.
It's incredibly frustrating.

 

[johnwm]

If you are running the app from a server you need to register your DLLs on the individual workstations rather than on the server.

I'm sure that you've already run a dependency walker to make sure that your DLL doesn't use any other DLLs

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

 

[robinsql]

The app only runs on a server as a scheduled task. It is not use by any other workstations, so that should not be a problem.
Thanks anyway.