Microsoft KB Archive/259388

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

Article ID: 259388

Article Last Modified on 4/22/2001

-

APPLIES TO


 * Microsoft Visual InterDev 6.0 Standard Edition

-



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 &quot;Field One&quot;. 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.

Keywords: kbprb KB259388

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.