ADO basics 1

[safra]

After looking at the BDE I am now trying to figure out how to work with ADO.

I am trying to show the records of a paradox file in a dbgrid. With the BDE you can connect directly from a TTable to a table. With ADO it seems you first have to create a Data Source (after selecting Microsoft OLE DB Provider for ODBC Drivers) and then you can connect to it through a Data Link file or Connection String. I have searched for information about this but I still can't figure what this Data Source exactly is and how you can create it?

Is there anyone who can help me with this?

Thanks,
Raoul

 

[whosrdaddy]

you don't need access on the client machine, what you do need are the ADO client DLL's. these are included in microsoft's MDAC (database access components). if your target client has XP, you don't have to do nothing else you should deploy MDAC (must be at least version 2.6 or later) with your app. MDAC can be downloaded from M$ or just google "MDAC_TYP.EXE" which is the name of the installation file...

happy programming !!!

 

[safra]

Thanks!

 

[Griffyn]

For machines prior to Win2000 (i think), you'll also need to download and install Jet, which is the database engine Access uses. Jet and MDAC are separate downloads from Microsoft.