>>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.
>

Can these options be set programmatically? The reason I ask is I have several different applications that access to same DBC and use a connection contained in it. I would like each application to be able to set the APP and WSID at runtime.