>I'm using the following to connect to SQL 2000/2005
>
>
>DRIVER=SQL Server;SERVER=10.0.0.4;UID=xxx;PWD=xxx;APP=Main.exe.PC1.USER1;WSID=PC1;DATABASE=AAA;QueryLogFile=Yes;Network=DBMSSOCN;Address=10.0.0.4,1433
>
>
>Can the APP property be updated after connection has been made?
Why? You know your application name beforehand, didn't you?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.