Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What replaces the ODBC Data Source Administrator?
Message
From
03/10/2006 12:27:27
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01158917
Message ID:
01158931
Views:
15
>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
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform