Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Detect active users at SQL Server
Message
 
To
14/11/2011 14:55:54
Metin Emre
Ozcom Bilgisayar Ltd.
Istanbul, Turkey
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01528779
Message ID:
01528866
Views:
45
>>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!
____________________________________
Previous
Reply
Map
View

Click here to load this message in the networking platform