DLLs registered wrong?

[griffindj]

Hello all,

I'm a J2EE Developer. I'm rewriting an existing ASP/VB app into Java/JSP. But until then I've got the sad task of maintaining some shmucks old code. It's asp with a SQL Server backend. It also uses somehting like 5 dlls to generate reports in word and excel. I've got his web app up and running on IIS 6.0 (Server 2k3).

The database connection is there and it's running the querries with no problem... but the report generation is where it craps out. It uses the asp to call a stored procedure which sends the data back to the asp with in turn passes it along to the dll to spit out the Excel Spreadsheet/Doc. I'm getting this error. (in this case the dll's name is SimpleExcel.dll)

SimpleExcel error '800a01ad'
ActiveX component can't create object

C:\INETPUB\WWWROOT\IRMAI\IRMAI_V2\TRAVEL\../dataadmin/traveldump_process.asp, line 21

I've done some research. His install documenation (which is incomplete and vague at best) says to use MTS to register the components. I'm not sure what this meant so I used the Component Services Manager to create a new app and register those dlls. Did not work, so I unregistered and then re-register them the only way I know how (regsvr32) but still same error. I googled it and read something about permissions on the dlls so I granted the GROUP EVERYONE full control... and still same.

Did i just miss something in the MTS registering or ...gasp did this guy hard code something in his dlls? In that case shoot me in the foot.

Can a Java Developer get some help from you Microsoft guys?