Error: Can't create ADODB.Recordset

[Lbob]

Hi

I've got an asp page that has some client side vbscript on that runs a SQL stored procedure. This works fine on 1 pc but I receive the can't create Active X object ADODB.recordset error on another pc and I can't work out why.
Any ideas?

Cheers
Lbob

 

[Tarwn]

If your creating the object client-side then that means that:
a) all your clients need to have the MDAC installed
and
b) you need to be very very careful what rights are given to the username nad password that your giving out to the whole world that views your website

Personally I would never allow anyone, o rmyself, to do client-side dataabse connections. It's just asking for someone to abuse the login informaiton I'm sending to them to try and break my database server.

-T