Hi Darren ----

In an earlier message, Jayesh Patel and Don West got this to work...modify as needed:

DECLARE Integer SQLConfigDataSource in odbccp32.dll;
Integer, Integer, String, String
settings="DSN=aw40"+chr(0)+;
"Description=ESDK autotest DB"+chr(0)+;
"SourceDB=c:\aw20\aw20.dbc"+chr(0)+;
"SourceType=dbc"


>I know that in visual basic you can creat a dsn odbc connection on the fly. Can you do this is visual foxpro. I have searched everywhere but have been unable to find any information on it.
>
>Thanks
>Darren in Atlanta