Difference between revisions of "ADO Database Connection VB6"
From Free Knowledge Base- The DUCK Project: information for everyone
m |
|||
| Line 6: | Line 6: | ||
* RecordSet Object | * RecordSet Object | ||
| + | == Connection Object == | ||
| + | === Properties === | ||
| + | |||
| + | * ConnectionString | ||
| + | * Provider | ||
| + | * Mode | ||
| + | * CursorLocation | ||
| + | * ConnectionTimeout | ||
| + | * CommandTimeout | ||
| + | |||
| + | === Methods === | ||
| + | |||
| + | * Close | ||
| + | * Open | ||
| + | |||
| + | == Command Object == | ||
[[Category:Computer Technology]] | [[Category:Computer Technology]] | ||
[[Category:Programming]] | [[Category:Programming]] | ||
[[Category:VB6]] | [[Category:VB6]] | ||
Revision as of 11:25, 30 October 2007
The old database access method using Jet has been replaced in VB6 by the new ADO or Active Data Objects. ADO makes it easier to access data from existing databases such as a Microsoft Access database or from an ODBC database connection such as MS SQL or Oracle.
Three Important objects in the ADO object model are:
- Connection Object
- Command Object
- RecordSet Object
Connection Object
Properties
- ConnectionString
- Provider
- Mode
- CursorLocation
- ConnectionTimeout
- CommandTimeout
Methods
- Close
- Open
