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

Article translations Article translations
Article ID: 259388 - View products that this article applies to.
This article was previously published under Q259388
This article has been archived. It is offered "as is" and will no longer be updated.
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.

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:
  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.

Status

This behavior is by design.

Properties

Article ID: 259388 - Last Review: October 26, 2013 - Revision: 2.0
Applies to
  • Microsoft Visual InterDev 6.0 Standard Edition
Keywords: 
kbnosurvey kbarchive kbprb KB259388

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com