thanks.
I found it. Here it is:
DECLARE INTEGER SQLConfigDataSource IN odbccp32.DLL INTEGER, ;
INTEGER, STRING, STRING
settings= "DSN=mydsn" +CHR(0)+;
"Description=my description" +CHR(0)+;
"SourceDB=c:\data\mydb.dbc" +CHR(0)+;
"SourceType=DBC"
x = SQLConfigDataSource(0,1,;
"Microsoft Visual Foxpro Driver",settings)
The same API, when used with SQL server, has the attributes:
SERVER=servernam DATABASE=pubs, etc., in the settings.
Bharat Sanghvi
Vice President, Information Technology
Deyta
Continuous Quality Measurement Systems