Dunno if you've solved this yet, but I'm connecting from PowerBuilder 9 using OLEDB and the following connection string and I'm successfully setting the application name:

Provider='SQLOLEDB',DataSource='myserver',Database='mydbname',PROVIDERSTRING='App=myappname',IntegratedSecurity='SSPI'