I am using such a Connection String
Local $sMyProgramName = 'mLipok'
Local $sConnectionString = "DRIVER={SQL Server};SERVER=" & $server & ";DATABASE=" & $db & ";uid=" & $username & ";pwd=" & $password & ";" & "Application Name=" & $sMyProgramName & ';'
Now when I use one of the following SQL commands
sp_who2
SELECT * FROM sys.dm_exec_sessions
then I get as a result
ProgramName = AutoIt v3 Script
program_name = AutoIt v3 Script
I want to change the Program Name in SQL instance to my true program name .
What I'am doing wrong ?
I will be grateful for your help.
mLipok
EDIT:
links which I used to check my SQL knowlege:
http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring(v=vs.110).aspx
http://www.connectionstrings.com/use-application-name-sql-server/
http://www.sqlteam.com/article/sql-server-connection-string