Visual Basic Q&A

As a software engineer, I focus on .NET, especially asp.net, C#, WCF and so on, and I am also very interested in Search Engine Optimization.

Entries Tagged ‘Data’

BUG: Queries or Views Do Not Appear in Data Form Wizard

Symptoms
When you use the Data Form Wizard, queries or views do not appear in thelist of available record sources.
Resolution
The Data Form Wizard incorrectly queries only for tables to populate thedrop-down combo box of available record sources.

BUG: Property Page of Remote Data Control Causes an Error

Symptoms
Pressing the ESC key while the cursor is in the SQL text box of theGeneral Tab in the property page of the Remote Data Control causes a blankGeneral tab. When you click the Colors tab and then click the General tabagain, an application error occurs and Visual Basic ends. The SQL text boxcan be empty or contain characters. Clicking the Cancel button on thewindow correctly closes the window. This behavior only occurs under theWindows 95 operating system.To work around this behavior, programmatically set the properties ofremote data control or use the Properties window of the Remote Data Objectto set the properties.
Resolution
Microsoft has confirmed this to be an issue in the Microsoft productslisted at the beginning of this article. Microsoft is researching thisissue and will post new information here in the Microsoft Knowledge Baseas it becomes available.

BUG: Private Databound UserControl Loses DataBindings in EXE

Symptoms
A private UserControl loses it Data Bindings when compiled to an EXE.
Resolution
Close the form containing the UserControl before making the EXE.

BUG: No Data Source Name Generates Run-Time Error Using RDC

Symptoms
When using Microsoft’s Remote Data Control 2.0 (RDC) without a User orSystem DSN in the ODBC Data Source Administrator, trying to set the RDC’sDataSourceName property generates a run-time error.
Resolution
Create a DSN under ODBC or upgrade from MSRDC20.ocx version 5.00.3714 (or5.01.4319), which is “Microsoft Remote Data Control 2.0,” to MSRDC20.ocxversion 6.00.816, which is “Microsoft Remote Data Control 6.0.”

BUG: Font Changes After Open Stored Procedure in Data View

Symptoms
When you open a Data View Stored Procedure Design window, the font of theData View window changes to the font of the Code window.
Resolution
To restore the font, you have to exit Visual Basic and restart.

BUG: Error 424 Adding Data Object Wizard-Created Ctrl to Form

Symptoms
When you try to place a user control that was created using the Data ObjectWizard onto a form, Error 424 (“Object Required”) occurs.
Resolution
When you place a user control on a form, that control’s Resize event isexecuted. If you create a list box or combo box type of user control usingthe Data Object Wizard, that control’s Resize event refers to the containedlist box or combo box incorrectly and causes error 424, “Object required.”