Greeting;
 
   I am writing a DCOM component using VB and I would like
to on the fly decide the correct provider to use pending
on the types of database. For example:

   For Access 2000, I would set my provider as below:

          "Provider=Microsoft.Jet.OLEDB.4.0"

   The question now I am trying to find out is how can I
determine the type of databases the user is using and set
the provider on fly (of course one way to display the data link
component for user to select, but some users are not familiar with
this)?

   Also, is there a way to determine ALL the databases user is having 
and database version ?

   Thanks.