Connection Strings - the APP element

[star1984]

hi,
Just wondering, if anyone can tell me the significance of the APP element in a connection string.
I have a pivottable in an old Excel workbook that I've inherited.
I have a central connection file that I usually get all my Excel files to use when determining a connection - this is normally used for query tables - this has always worked fine.
Now I am updating the pivot file's connection string using this central file.
for some reason its not working with this particular workbook - I think it is to do with the difference between query tables and pivot tables (the APP element).
The old connection string reads as follows
"ODBC;DRIVER=SQL Server;SERVER=server1l;UID=12000;PWD=00012;APP=Microsoft Office 2003;DATABASE=MSSPALDING"

The one I plan to update it with is as follows (generated by my central file)
"ODBC;DRIVER=SQL Server;UID=username;PWD=S7pUDruC;APP=Microsoft® Query;SERVER=server1;DATABASE=MSSPALDING"
But this doesn't work.
However when I changed my central file as a test with the APP element changed it worked
DRIVER=SQL Server;SERVER=server1;UID=username;PWD=S7pUDruC;APP=Microsoft Office 2003;DATABASE=MSSPALDING


I've only ever used APP=Microsoft® Query before and am very new to VBA so have not come across this.