How to create a system DSN using SQLconfigDataSource

[APS]

I can create a new user DSN using the SQLConfigDataSource command, but what do I change to create a system DSN?

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

settings="DSN=testing"+chr(0)+;
"Description=VFP ODBC Driver"+chr(0)+;
"SourceDB=v:\tmwinabs\abs\data\contacts.DBC"+chr(0)+;
"SourceType=DBC"

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

Thanks,
Anthony

 

[wgcs]

I abandoned trying to create any kind of DSN when I found SQLStringConnect ... if you're trying to programmatically create DSNs, then your program knows all the settings already, so why not keep changes in the ODBC settings from affecting your program by making your program ALWAYS responsible for the connection, with SQLStringConnect?

 

[APS]

I attempting to avoid having to set up the ODBC source on all the machines. Which I will have to do first to use the SqlStringConnect command, correct?

 

[wgcs]

You only need to have the ODBC driver installed, which should install at the same time as your VFP runtimes & .EXE file simply by selecting the "Microsoft Visual Foxpro ODBC Driver" merge module in InstallShield (or whatever installation builder you use).

The SQLStringConnect includes all the necessary parameters so that no DSN is necessary, see:

http://fox.wikis.com/wc.dll?Wiki~DSNLessConnections~VFP

http://fox.wikis.com/wc.dll?Wiki~VFPCommandSQLConnect

http://fox.wikis.com/wc.dll?Wiki~ProgrammaticallyCreatingDSNs~VFP