Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Detect active users at SQL Server
Message
De
15/11/2011 07:02:36
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:
01528921
Vues:
58
>>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)
>
>This is a connectionstring I use against a SQL2008 database from VFP9.
>
>gcConnectionString = "Driver={SQL Server Native Client 10.0};server=DELL2800\SQL2008;Database=HeartlandCube;Trusted_Connection=Yes;APP=MDP_using_native_client"

I put the APP parameter end of the string and it's working now.
Thank you,
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform