How do I programmatically add a Visual Foxpro ODBC source ?
MSDN only has an SQL server example in C++.
(I don't mind writing this in C++ as long as I can make it work)
This works:
SQLConfigDataSource(NULL,
ODBC_ADD_DSN, "SQL Server",
"DSN=MyNewDSN\0DESCRIPTION=SQLConfigDSN Sample\0"
"SERVER=ATHENA\0ADDRESS=ATHENA\0NETWORK=dbmssocn\0"
"DATABASE=pubs\0");
This does not:
SQLConfigDataSource(NULL,
ODBC_ADD_DSN,"Visual Foxpro Database",
"DSN=MyTest\0DESCRIPTION=DSI Test ODBC\0"
"DATABASE=c:\\dsi\\mydata.dbc\0");
I even tried using the attribute PATH instead of DATABASE.
thanks
Bharat
Bharat Sanghvi
Vice President, Information Technology
Deyta
Continuous Quality Measurement Systems