>>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 can't believe I found it this soon. Thar she blows .
I can't test it now but see if you can make it work and let me know.
In VB Script for ASP they say you can
Connection.Open "driver={Microsoft Access Driver (*.mdb)};dbq=c:\inetpub\aspsamp\advworksadvworks.mdb"
from
http://www.15seconds.com/faq/Question.aspHTH
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin.www.TrueGeeks.com