>>I'm not sure what you mean. Maybe I don't understand the question. I don't think you can create a DSN from inside Fox Pro. To the best of my knowledge you create the DSN on the machine from ODBC data source admin program and then call that DSN from the fox pro program such as
>>SQLCONNECT(dsnname,'username','password') TO gnConnHandle uname and pword optional.
>
>Yes, excatly, so let say at run time, we found that the DSN is not present. This is why I would like to create it at run time instead of having someone to have to go in Control Settings ODBC 32.

I know I saw on an ASP web site a way do sort of do that through ASP. I will try and find it and let you know if It looks like it can be move to VFP or duplicated. May someone else knows already because It was quite awhile back and I'm not sure where I saw it so it could take me a while.