PRB: 800a0bb9 Error Occurs with Data Bound Design-Time Control (259388)
The information in this article applies to:
- Microsoft Visual InterDev 6.0
This article was previously published under Q259388 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.
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.
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.
STATUS
This behavior is by design.
| Modification Type: | Major | Last Reviewed: | 4/22/2001 |
|---|
| Keywords: | kbprb KB259388 |
|---|
|