Someone told me yesterday that I could use the code below to create an ODBC Data Source programmatically, it works fine. The problem I have is that I need to create a Data Source using CLIENT ACCESS ODBC DRIVER (32-bit) from IBM and I don't know where to find all the parameters I need to supply from my program to create the Data Source.

This driver asks for other things besides the DSN, Description, SourceDB and SourceType parameters. Any suggestions? Any comments will be welcome. Thank you in advance.


DECLARE Integer SQLConfigDataSource in odbccp32.dll Integer, ;

Integer, String, String
settings="DSN=VFP Tables"+chr(0)+;
"Description=VFP ODBC Driver"+chr(0)+;
"SourceDB=c:\vfp\samples\data\customer.dbf"+chr(0)+;
"SourceType=DBF"

? SQLConfigDataSource(0,1,"Microsoft Visual FoxPro Driver",settings)