This is a discussion on "ADODB.Recordset error '800a0bb9'" within the Databases section. This forum, and the thread "ADODB.Recordset error '800a0bb9' are both part of the Program Your Website category.
|
|
|
|
|
 |
||
ADODB.Recordset error '800a0bb9'
|
||
| Notices |
 |
|
|
LinkBack | Thread Tools |
Jul 15th, 2005, 18:55
|
|||
|
|||
|
ADODB.Recordset error '800a0bb9'
I'm new to SQL and I'm having problems (probably due to a stupid mistake). While attempting to update an access database I get the following error message:
ADODB.Recordset error '800a0bb9' Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. Here's my SQL statement: UPDATE Servers SET ClusterID=1 WHERE ServerName='espnbar01' OR ServerName='newsweb01' OR ServerName='newsweb02' OR ServerName='newsweb03' OR ServerName='newsweb04' OR ServerName='newsweb05' OR ServerName='newsweb06' OR ServerName='newsweb07'; ClusterID is a number whereas serverName is text 
|
|
|
|
Jul 15th, 2005, 19:09
|
|||
|
|||
|
is ClusterID an autogenerated field?
|
|
Jul 15th, 2005, 21:09
|
|||
|
|||
|
Ah, as it turns out the problem was with the read/write settings. Thanks for the suggestion anyways.
|
|
| Tags |
| adodbrecordset, error, 800a0bb9 |
| Thread Tools | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| ADODB.Connection error '800a0e7a' | jpresley | Classic ASP | 0 | Oct 23rd, 2006 17:52 |
| recordset/table display | Eclipse414 | Web Page Design | 4 | Dec 25th, 2005 21:02 |
| Importing RecordSet to .asp file | tolis | Classic ASP | 8 | Nov 23rd, 2005 20:23 |
| importing txt file to SQL with recordset | EnvY | Classic ASP | 21 | Mar 28th, 2005 11:22 |
| passing recordset to next page? | Monie | Classic ASP | 1 | Sep 25th, 2004 07:53 |
