Setting ODBC Data Source through VB

[jbart]

Hi,

I have several applications written in FoxPro and would like to access the databases from VB. On my development PC, I use the Data Sources Control Panel to create a new Data Source Name and assign it a driver and location of the FoxPro database.

If I want to distribute the VB executable to other machines, is there a way through VB code to set up the Data Source? Or will the user need to use the Control Panel to set it up?

Or am I going about the whole concept the wrong way?

Thanks for any information.

[CoreyS]

Check out this URL:

http://support.microsoft.com/support.../1/46.asp?FR=0

[jbart]

Thanks for the link. That has taken me close to getting this to work, but I obviously am missing something in the connection string.

If anyone out there in VB land has a working example of creating a Data Source for a Visual FoxPro database container using the SQLConfigDataSource API, I would appreciate a post of the code.