Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-09 : 08:32:22
|
| Debbie writes "Is there anyway I can set the APP_NAME via Transact SQL? I connect to SQL via ODBC (SQLCONNECT(odbcname, userid, password))from VFP and the APP_NAME returns:Microsoft® Visual FoxPro® Is there anyway I can set this?Many ThanksDebbie" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-09-09 : 08:33:23
|
| Yes, but it's not a T-SQL statement. In your ODBC connection string, add "APP=MyAppName;". That will change the default from Foxpro to whatever you want it to be. This also works in OLEDB connection strings as well. |
 |
|
|
Lulu
Starting Member
1 Post |
Posted - 2004-10-08 : 03:10:09
|
Cool  Thank you robvolk. I searched this info. Google showed me your post.Exactly what I needed.... and it works!Cheers from Switzerland  |
|
|
|
|
|
|
Application Name Value (APP_NAME)