OLE DB and ADO

[gwt]

I have been asked to do an application using OLE DB and ADO which will connect to an Access database and a SQL server. Does VB 6.0 Pro come with all that I need, or is there more. From MS's web site, I understand that I need some third party controls, like the ISGData control. Is this true? Tell me what you know, and any referencing web sites to help me get started would help. Thanks

[Jimbob]

your installation should contain everything you will need to manupulate an access db using ADO

it's a good idea to put ServicePack 4 for visual studio on, as this will give you ADO 2.5


the standard DBGrid that comes with VB will bind to an ADO recordset - purchasing a grid will just give you more functionality. All the other types of control( text boxes, dblists etc) will bind to ADO as easily as they would to DAO

hope this is of some help...

[gwt]

Your information is useful. Thanks. But, how does ADO and OLE DB go together. Are they two separate concepts, or is ADO a functionality of OLE DB. Is ADO the only thing i need to be concerned with at this time?

[JHausmann]

ADO is the Object based interface to OLE DB.

[Clunietp]

gwt

As JHausmann stated, ADO is the object based (VB friendly) interface to OLEDB.

You can't directly interface with OLEDB for some technical reason I didn't care to remember, so you only have to concern yourself with ADO at this time.