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

View products that this article applies to.

This article was previously published under Q259388

Expand all | Collapse all

SYMPTOMS

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.

Back to the top

CAUSE

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.

Back to the top

RESOLUTION

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:

Open the properties of your Recordset Design-Time Control and select the General tab.
Select SQL Statement as your Source of data.
Enter a valid SQL statement. Use the AS statement to replace the field names that contain spaces.
Click Close.

Back to the top