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

I don't know for sure but you can try DBSETPROP(< connection name >, "CONNECTION", "ConnectString", < new connection string >).