>I have a Visual FoxPro database application.
>
>It has been common for us to write programs in C++ to collect data in realtime, save the data in files, analyze those data, and then transfer the results into our VFP database use ODBC.
>
>However, since Microsoft no longer provides an ODBC driver for VFP, we have switched to OLEDB as a way of getting data from our C++ applications into our VFP database.
>
>I am fairly new to this type of interface.
>
>My question: Microsoft provided the "ODBC Data Source Administrator" to set up datasources. My C++ programs could access the list of data sources created by that administrator to allow the user to select the database that would receive the results. I have not been able to find a similar tool to create a list of available data sources that can be used by OLEDB.
>
>I note that Excel has the kind of interface that I expect to be available to me. In Excel, the user can select Data...Import External Data, and it brings up a dialog box that gives access to defined data sources. Is this facility available to my C++ programs? Or something like it? I would like to use it to allow my user the option of selecting my VFP database to receive the calculated results.
>
>Thanks in advance for your help.
>
>Jim
Any vfp tables is your datasource IMHO. If you want them to be kept in somewhere then you could use a plain text file to store paths. Or if want something like ODBC administrator then you could create .udl files.
Cetin