URGENT HELP NEEDED on VBSCRIP RUN TIME ERROR

[kazai]

Hi,
I'm getting the following error:

Error Type:
Microsoft VBScript runtime (0x800A01A8)
Object required: 'ADODB'
/Malavika/PFEfiles/SIGN_IN_ASP_files/Insert.asp, line 24

This happens when I try to execute a pure back-end ASP file.

The line in my code that this error points to is:

set cnn = server.CreateObject(ADODB.connection)-- THIS ONE
set adoRs1 = server.CreateObject(ADODB.recordset)
set adoRs2 = server.CreateObject(ADODB.recordset)
cnn.Open "...."
strSQL = "..."
adoRS.open(strSQL)

please help...i'm getting close to my dead line, and i'll be dead if i don't get this working!!!
thanks,
radhika.

 

[asuknow]

Have you really install ADO in your ASP?
I know by default is should be there.
Another possibility is that some important files
got damaged somehow and the database engine won't
work.

If you have a PC, probably you can install Personal
Web Server from you Windows CD or download it from
microsoft. Try this and see whether you ASP script
works under PWS.

Hope this helps, good luck!

 

[JohnYingling]

set cnn = server.CreateObject("ADODB.connection&quot-- THIS ONE
set adoRs1 = server.CreateObject("ADODB.recordset&quot
set adoRs2 = server.CreateObject("ADODB.recordset&quot

By the way. You waste time creating an emopty recirdset when subsequent instructions are going to return a record set anyway. Only create what you need to execute, not waht is going to be returned.

http://www.VBCompare.com

http://www.VBSortGen.com