[RBG7-L] - SqlServer Connection String for DSN-Less Connection

[MikeB]

Bernie,

This worked in RB7:



where Phoenix is my server where SqlServer resides;

sconnect ';Driver={SQL
Server};Server=PHOENIX;Database=Northwind;Trusted_Connection=yes'
sattach 'customers'
bro * fro customers
sdisconnect ';Driver={SQL
Server};Server=PHOENIX;Database=Northwind;Trusted_Connection=yes'


Windows Integrated security must be incorporated on the SqlServer installation,
otherwise you will have to use the
UID=SomeUserID;PWD=SomePasswordThatHasTheAppropriateLoginForSqlServer addition
to the connection string;