I'm trying to discover how to create a NEW
ODBC Data Sources Using SqlConfigDataSource

*] First I use the Declare DLL function

DECLARE Integer SQLConfigDataSource in odbccp32.dll Integer, Integer,;
String, String

*] Then I create a string containing the settings to the driver I'm using

settings="DSN=TestVFP"+chr(0)+;
"Description=NEW_DSN_SQL7"+chr(0)+;
"Server=Pro200"+chr(0)+;
"SourceDB=C:\mssql7\data\policia.MDF"+chr(0)+;
"SourceType=MDF"+chr(0)+;
"UID=Peter"

y = SQLConfigDataSource(0,1,"TestVFP",settings)



Problem: Which are the apropriate settings to create a NEW ODBC System DSN to connect from my Fox application to SQL Server 7.0.

Could someone Help me please, with the correct
seetings and the order of those settings.

Thank's in Advance..

Peter Wagner
pointinfo@limeira.com.br
Brazil - SP - Limeira

* "DRIVER={SQL Server};Exclusive=No;SourceType=MDF;Deleted=No;
* SourceDB=C:\mssql7\data\policia.MDF;Server=Pro200;UID=Peter;pwd=123"