Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What replaces the ODBC Data Source Administrator?
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
What replaces the ODBC Data Source Administrator?
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01158917
Message ID:
01158917
Views:
71
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
Next
Reply
Map
View

Click here to load this message in the networking platform