FAQs about Data Source

1. Is OleDBPro also able to open Excel, Paradox, dBase, Lotus, Exchange/Outlook, HTML, Text etc?
           Yes! You can use MS Jet provider 4.0 with ISAM drivers to open these database files. For how to open an Excel file, click here. Here is the example to open a Paradox database file.
   
           CODataSource    ds;
   
           //set a extended property
           ds.SetProviderString(L"Paradox 5.X;");
           ds.SetServer(L"C:\\YourDirectoryHoldingParadoxFiles\\"); 
           ds.Open(L"Provider=Microsoft.Jet.OLEDB.4.0;");
   
           Similarly, you can use the method to open various files of dBase, Lotus, Exchange/Outlook, HTML, Text, and so on.

2. Is there any data source which can't be opened through OleDBPro?
           OleDBPro can open all the data sources with one of the following drivers available:
           a. An OLEDB provider;
           b. An ODBC driver;
           c. An ISAM driver recognizable to MS jet provider 4.0 or other providers.

3. Suppose that I need to open a data source with a set of provider-specific properties. How can I set the set of properties?
           It is easy. See here, and you need to overwrite CODataSource::PostProcess.

4. What connection string is for an OLEDB provider. Where can I find the connection string for a provider?
           Here is a wonderful site in http://www.able-consulting.com. You can also check inside MSDN or the documentation of your provider. There are many examples at Microsoft support web site too.