I get 800a01fb this error msg...Any one please help meout

[amitpatil]

Hi,

I have 4 web pages which collects data and insert in database. Since couple of days i am getting following errors. ( there r diff kinds of errors i get each time ): They are in sequence as i get them

1.
Error Type:

Active Server Pages error 'ASP 0115'

Unexpected error

/iisHelp/common/500-100.asp

A trappable error (C0000005) occurred in an external object. The script cannot continue running.

Microsoft VBScript runtime error '800a01fb'

An exception occurred: 'Open'

/common/db_connect.asp, line 6

2.
Error Type:
Microsoft VBScript runtime (0x800A01FB)
An exception occurred: 'Open'
/common/db_connect.asp, line 6



3.
Error Type:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/register2.asp, line 196


4.
The remote procedure call failed and did not execute.

5.

Error Type:
Provider (0x80020005)
Type mismatch.
/register.asp, line 152


Are these errors are depend on each other...
Would any please help me out i have search lots of places but no luck

Thanx

[iam_clint]

Error Type:
Provider (0x80020005)
Type mismatch.
/register.asp, line 152

can you give us the lines of code that are throwing these errors?

[amitpatil]

Set rs = CreateObject("ADODB.Recordset")
sql= "SELECT * FROM members"
rs.Open sql, OBJdbConnection, 3, 3
coloum =array("username","password","valid_member","membe r_level_id","new_profile","from_date","from_time")
values =array(username,password,0,4,1,today,now_time)
Error is showing this line---> rs.AddNew coloum,values
rs.Close


from list of errors i gave when the 1st error comes then following errors stats coming.
Above code does not give me any trouble till i do 2 transactions between database and user. no.1 error pops up at the time of 3rd(Most of the time) transaction. Then that error stays for period of time on all page on server ( here it is looks to be some think related to sessions and some objects)