>>You should be able to set your application name in the sqlconnection. Can you post your connection string you are using?
>
>
>I tried both of them:
>
>lcCstr="DRIVER=SQL Server;Application Name=OZCOM-STEP;SERVER="+Alltrim(M.XServer)+;
> ";uid="+Alltrim(M.XUser)+";pwd="+Alltrim(M.XPassword)+";database="+Alltrim(m.xdatabase)
>
>
>lcCstr="DRIVER=SQL Server;ApplicationName=OZCOM-STEP;SERVER="+Alltrim(M.XServer)+;
> ";uid="+Alltrim(M.XUser)+";pwd="+Alltrim(M.XPassword)+";database="+Alltrim(m.xdatabase)
>
>lcCstr="DRIVER=SQL Server;App=OZCOM-STEP;SERVER="+Alltrim(M.XServer)+;
> ";uid="+Alltrim(M.XUser)+";pwd="+Alltrim(M.XPassword)+";database="+Alltrim(m.xdatabase)
If nobody else comes up with a solution before I get home this evening I'll post an example of one of the connection strings I used in one of my VFP apps (I can't get to my VFP code until then).
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________