asp error

[Thai]

Hello I set up an ASP page on a NT Server 4.0 with the option pack running IIS. When Im at another computer and I try to load that page on the NT server, I get a vbscript runtime error of 800a01ad, "ActiveX Cannot Create Object". But it runs fine on my machine and if I put that ASP page on a DIFFERENT NT server and try to hit it, it works fine. So it seems to just be this one machine, how can I solve this? Thanks!

Thai

[Clunietp]

what objects are you creating within your ASP script?

[Thai]

I am creating an ADO connection, but the error says it fails creating the connection but it actually fails the line right AFTER it creates the connection, it fails at the part where it tries to actually connect.

set cn = createobject(...
cn.open <- fails here.

thanks for the help,
Thai

[Clunietp]

why aren't you using Server.Createobject?

what does your connection string look like?

what version of the MDAC do you have installed on that server?

[Thai]

Thanks, I installed MDAC 2.5 and it started to give me another error. I got an authencation error, it wouldn't let the username/pass in. I was using a DSN instead of a full connection string. So I changed it to use a connection string and no dsn and it worked, wierd. So MDAC was the first problem, and the DSN was the second, I still haven't figured out what was wrong with the DSN yet. Thanks for all your help!

Thai

[Clunietp]

DSNs can be problematic, you are almost always better off using a native OLEDB connection string