[DUG]: ADO

[Robert martin]

I want to build an app that can talk to any SQL DB dependant on driver availability.  My initial thought is to use ADO as this can link to any OLEDB or ODBC driver.  (1) Would ADO be the best option?   Assuming ADO is the best option.  In design mode when creating a connection string a wizard appears that allows simple creation of the string based on the drivers on the system. (2) Is there any way of 'exposing' this system at runtime so a user can configure their own settings ?  (3) If not do I have to resort to building my own connection string generator?  (4) Are there any likely gotchas I may run into?   Any comments and suggestions would be gladly appreciated, we are just determining feasibility at this stage.   I have stayed away from the dbExpress stuff (which I have not used) as I understand this would require DBExpress drivers for each DB kind.      Rob Martin Software Engineer   phone 03 377 0495 fax 03 377 0496    web www.chreos.com