>When I'm running my application from the foxpro7 command window, and then I exec the sp_who2 SP, the programname shows Microsoft Foxpro. If I run the application as an EXE, the programname is blank. Is there a way to store my actual program name in the programname field when I create a connection?
>
>Thanks

There is two options you can set in the ODBC connection string: App=myapp; and WSID=myworkstation;. I don't know wich one shows in sp_who2. The host_name() function in Sql Server returns a value of App option.