You are here: Programming Environments > Programming Environments > Visual Basic 6.0

Using the Scantron OLE DB Provider with Visual Basic 6.0

Microsoft® Visual Basic® 6.0 has several tools to enable rapid application development with the Scantron OLE DB Provider (Scantron.Oledb). The Microsoft® Visual Database Tools Query Designer enables you to design database queries visually, or you can use SQL statements. You can test the queries against the Scantron OLE DB Provider. The MSDN has excellent documentation to help you leverage this powerful tool.

NOTE:Scantron.Oledb supports a subset of SQL that is limited to commands that relate to scanned data. For more information, see the Data Services Technical Overview.

Visual Basic® 6.0 also provides ActiveX Data Bound controls. These controls can be added to your project to enable you to easily connect to data. The Scantron OLE DB Provider directly supports any control that is ADO or OLE DB aware. You can also use standard edit box, label, and checkbox controls although they would require more programming.

The following are some typical examples of how to set data specific properties at design time via the Visual Basic® form designer. These examples not exhaustive nor do they reflect the full capabilities of the Scantron OLE DB Provider.

Microsoft® ADO Data Control 6.0 (SP4) (OLEDB)

Microsoft® DataGrid Control 6.0 (SP5) (OLEDB)

Microsoft® DataList Controls 6.0 (SP3) (OLEDB)

Microsoft® DataCombo Control

Standard Edit Box, Label, and ComboBox

 

 

See Help on Help for additional information on using this help file.

See Scantron Technical Support for additional information on technical support and training options.

See the ScanTools Suite System Requirements for further details on hardware and software requirements.

ScanTools is a suite of products; the specific information you want may appear in the help for a different module. If you don't find what you're looking for here, try one of the following:

  

Scantron Corporation

Customer Service (forms, products, and services):

1-800-SCANTRON (722-6876)

www.scantron.com

Technical Support:

1-800-445-3141

[email protected]

Copyright © 1998-2012 Scantron Corporation. All rights reserved. Use permitted only under license. www.scantron.com. No part of the Help or user guides may be reproduced in any form, or by any means, without express permission from Scantron Corporation.

LINKS TO THIRD PARTY SITES

This help system may contain links to third party websites ("Linked Sites"). The Linked Sites are not under the control of Scantron and Scantron is not responsible for the content of any Linked Site, including without limitation any link contained in a Linked Site or any changes or modifications to a Linked Site. Scantron is not responsible for web casting or any other form of transmission received from any Linked Site. Scantron provides Users with the ability to link the Assessment System to the Linked Sites as a convenience to you, and the inclusion of any link does not imply endorsement by Scantron of the Linked Site or any association with its operators.