Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
DSNless connection
Message
De
13/02/2013 16:09:01
 
 
À
13/02/2013 15:53:05
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
01565956
Message ID:
01565959
Vues:
64
This message has been marked as the solution to the initial question of the thread.
There is a \\ between the server and instance name on connStringA.


>
>
>ConnStringa = "DRIVER=SQL Server,SERVER=BILL-VAIO\\SQL2008FULL,DATABASE=safesignature,UID = myuid; PWD = mypw"
>
>ConnStringb ="Driver=SQL Server;Server=BILL-VAIO\SQL2008FULL;Database=safesignature;Integrated Security=SSPI"
>
>myuid and mypw belong to a SQL administrator will full rights to the DB.
>
>When I try gnHandle = SQLStringConnect(lcConnStringa)
>
>I get "myid is not at trusted connection"
>
>
>When I try gnHandle = SQLStringConnect(lcConnStringb)
>I connect fine.
>myuid and mypw work fine with a DSN.
>
>Any suggestions?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform