ASP problem on IIS 4.0

[Schwerzmann]

I wanted to run an ASP Database Connection on a IIS 4.0 (NT Server 4.0). The script works on every other IIS-Server. It starts with this line:

SET Conn=SERVER.CREATEOBJECT("ADODB.CONNECTION&quot

If I run it on the browser, it always returns the following error:

Microsoft VBScript runtime error ' 800a01ad'
ActiveX component can't create object

I tried a lot of possible solutions suggested on the Microsoft homepage and I reinstalled the Option Pack, but there's still the same error.

Reto

 

[NickBulka]

Get the latest MDAC from microsoft.

 

[Schwerzmann]

Thanks for your hint. I installed the latest MDAC (2.5) but there's still the same error.

Reto

 

[NickBulka]

The only other possiblity I can think of is that it's possibly a permissions problem. Other than that, I'm stumped.

 

[Schwerzmann]

Do you have an idea, what kind of permission could be wrong setted?

Reto Schwerzmann

 

[rstenton]

I had the some problem and got round it by registering the component with MTS. I still not sure whether this is a solution or just a workaround

 

[Schwerzmann]

Could you please give me an example how to do this? Recently I read about how to register components with MTS, but I don't know what kind of file i have to register or what it must contain.

Thanks. Reto Schwerzmann

 

[Schwerzmann]

Thanks for your hints. It was a permission problem. I created a new IUSR_...-profile with the same permissions and it worked surprisingly (no idea why).

But now I have another problem: the performance is very bad. For a simple database request it takes 9 sec. On every other IIS Server it takes less than 2 sec. There's not much traffic on the server. Could it be a setting problem of the IIS-Server?

Reto Schwerzmann

 

[Husein]

You could also register the component with REGSVR32.EXE which is located in your WINNT\SYSTEM32
Locate you OCX or DLL file and drag and drop. [sig][/sig]