Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DSNless connection
Message
From
13/02/2013 16:09:01
 
 
To
13/02/2013 15:53:05
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
01565956
Message ID:
01565959
Views:
62
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform