MS SQL - Connection String - sp_who2 - why ProgramName = "AutoIt v3 Script"

[mLipok]

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

Edited July 29, 2014 by mLipok

[mLipok]

One remark

the name "AutoIt v3 Script" is visible only if script is not compiled.

When used compiled script then SQL instance see ProgramName as blank/empty string.

[mLipok]

,,, any hint ?

[mLipok]

from here:
http://stackoverflow.com/questions/7164485/application-name-in-sql-server-when-connecting-from-classic-asp

ODBC connections will not pass the application name, but ADO connections will.

Edited August 11, 2014 by mLipok