?
Solved

VB6 Components and References

Posted on 2009-05-01
6
Medium Priority
?
590 Views
Last Modified: 2013-11-26
Please tell me what are these Components and References in a VB6 apps:

COMPONENTS:
- Microsoft ADO Data Control 6.0 (SP6) (OLEDB)
- Microsoft DataGrid Control (SP6) (OLEDB)
- Microsoft Windows Common Controls-2 6.0 (SP6)

REFERENCES::
- Visual Basic For Applications
- Visual Basic runtime objects and procedures
- Visual Basic objects and procedures
- OLE Automation
- Microsoft Active X Data Objects 2.5 Library
- Microsoft Data Binding Collection VB 6.0 (SP4)
0
Comment
Question by:rayluvs
  • 3
  • 3
6 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 2000 total points
ID: 24281698
COMPONENTS:
- Microsoft ADO Data Control 6.0 (SP6) (OLEDB)
  -> that is to put a ADO data control on your forms, which is to manipulate database data via oledb recordsets
- Microsoft DataGrid Control (SP6) (OLEDB)
  -> a full-blown data grid control
- Microsoft Windows Common Controls-2 6.0 (SP6)
  -> the second set of windows common controls, like listview, treeview etc.

REFERENCES::
- Visual Basic For Applications
- Visual Basic runtime objects and procedures
- Visual Basic objects and procedures
  -> this first 3 should not be removed, and are to give you access to the basic functions

- OLE Automation
  -> to support ole automation. this might be removed...

- Microsoft Active X Data Objects 2.5 Library
  -> ADO library, to connect to databases and run queries.
- Microsoft Data Binding Collection VB 6.0 (SP4)
  -> not sure, never used it. but I presume it's to dynamically bind some controls to a data source (ado records, for example)
0
 

Author Comment

by:rayluvs
ID: 24281768
Thanx


So if I were to work with databases (SQL, Access, etc.) I have to have both "Microsoft ADO Data Control 6.0 (SP6) (OLEDB)"  and "ADO library, to connect to databases and run queries."?

Whats "OLE Automation" used for?

I know you say you are nite sure, but "Microsoft Data Binding Collection VB 6.0 (SP4)" should also be included if I were to work with databases?

0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 24281977
the only things I include is this (to work with databases):

COMPONENTS:
- Microsoft Windows Common Controls-2 6.0 (SP6)

REFERENCES::
- Visual Basic For Applications
- Visual Basic runtime objects and procedures
- Visual Basic objects and procedures
- OLE Automation
- Microsoft Active X Data Objects 2.5 Library

data controls are not needed.
the data grid control is either too basic (limiting) or to cumbersome (taking control away) for a real data application.
a well-developed form with unbound controls works just well, using stored procedures on the database side to handle the data access in short.
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

Author Comment

by:rayluvs
ID: 24282142
Fully understood, thanx.

What about the "OLE Automation", what's used for?  Why would I want it in my VB app?
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 24282309
only if you need to automate other applications (for example ms office ...) via ole automation.
0
 

Author Comment

by:rayluvs
ID: 24283738
ok thanx
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Suggested Courses
Course of the Month13 days, 9 hours left to enroll

750 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question