Error '800a01b6' 
Author Message
 Error '800a01b6'

Hello!

I'm trying to access an Access97 database on an IIS-Webserver with
NT4.0. It is no problem to read data out of the tables. But i can't
write into a table. I already tried it by means of: conn.execute("Insert
into ....") with this try I got error 80004005.
Now I try it this way:

SQL = "SELECT * FROM personendaten"
Set rs = Server.CreateObject("ADODB.Recordset")
set conn = Server.CreateObject("ADODB.Connection")
conn.Open (DSN)
rs = conn.Execute(SQL)
 rs.AddNew Array("firstname", "name", "title"), Array(vfirstname, vname,
vtitle)

The result is the same (nothing), but the error message changed:

Microsoft VBScript runtime error '800a01b6'

Object doesn't support this property or method: 'rs.AddNew'

/aspsamp/pers_beurteilung/write.asp, line 103

I also tried the examples on www.asp101.com and checked a lot of other
asp-sites.
Can anyone tell me, what I'm doing wrong?

Thanks,

Wolfgang



Fri, 05 Apr 2002 03:00:00 GMT  
 Error '800a01b6'

The Connection.Execute method only returns a read-only, forward-only cursor.  Use the Recordset.Open instead, passing the SQL, connection, and an appropriate updateable cursor type.

--
Michael Harris

  Hello!

  I'm trying to access an Access97 database on an IIS-Webserver with
  NT4.0. It is no problem to read data out of the tables. But i can't
  write into a table. I already tried it by means of: conn.execute("Insert
  into ....") with this try I got error 80004005.
  Now I try it this way:

  SQL = "SELECT * FROM personendaten"
  Set rs = Server.CreateObject("ADODB.Recordset")
  set conn = Server.CreateObject("ADODB.Connection")
  conn.Open (DSN)
  rs = conn.Execute(SQL)
   rs.AddNew Array("firstname", "name", "title"), Array(vfirstname, vname,
  vtitle)

  The result is the same (nothing), but the error message changed:

  Microsoft VBScript runtime error '800a01b6'

  Object doesn't support this property or method: 'rs.AddNew'

  /aspsamp/pers_beurteilung/write.asp, line 103

  I also tried the examples on www.asp101.com and checked a lot of other
  asp-sites.
  Can anyone tell me, what I'm doing wrong?

  Thanks,

  Wolfgang



Fri, 05 Apr 2002 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Microsoft VBScript runtime error '800a01b6'

2. Microsoft VBScript runtime error '800a01b6'

3. Microsoft VBScript runtime error '800a01b6'

4. Runtime error ''800a01b6''

5. Microsoft JScript runtime error '800a01b6' with using push

6. error 'ASP 0115' Unexpected error

7. Run-time error '429': ActiveX component can't create object

8. Run-time error '-2147417846 (8001010a)': Automation error (error 440)

9. Run-time error '-2147417846 (8001010a)': Automation error (error 440)

10. VB script runtime error '800a01a8'

11. error 'ASP 0115'

12. Microsoft VBScript runtime error '800a000d'

 

 
Powered by phpBB® Forum Software