Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Detect active users at SQL Server
Message
 
À
14/11/2011 14:55:54
Metin Emre
Ozcom Bilgisayar Ltd.
Istanbul, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Database:
MS SQL Server
Divers
Thread ID:
01528779
Message ID:
01528866
Vues:
46
>>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!
____________________________________
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform