PRB: 800a0bb9 Error Occurs with Data Bound Design-Time Control

This article was previously published under Q259388
This article has been archived. It is offered "as is" and will no longer be updated.
When you use data bound Visual InterDev 6.0 Design-Time Controls, you may encounter the following error:
ADODB.Recordset error '800a0bb9'
The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.
/Project1/_ScriptLibrary/Recordset.ASP, line XXX
NOTE: The line number depends on whether Visual Studio 6.0 Service Pack 3 is installed.
This problem may occur because the bound field has spaces in its name, such as "Field One". Some databases allow spaces in field names. The Visual InterDev 6.0 ScriptLibrary does not delimit field names. As a result, a syntax error occurs.
If you must include spaces in database fields, you can work around this problem: bind your data to an SQL statement and use the AS keyword to create a new field name that does not contain spaces.

For example:
SELECT [Field With Space] AS Field_Without_Space FROM TableName				
To do this:
  1. Open the properties of your Recordset Design-Time Control and select the General tab.
  2. Select SQL Statement as your Source of data.
  3. Enter a valid SQL statement. Use the AS statement to replace the field names that contain spaces.
  4. Click Close.
This behavior is by design.

Article ID: 259388 - Last Review: 10/26/2013 15:39:00 - Revision: 2.0

Microsoft Visual InterDev 6.0 Standard Edition

  • kbnosurvey kbarchive kbprb KB259388