Mike,
I loaded sqlserver on my desktop, same machine as rbase.
so for server= What would I put? or just leave that parameter out?
Bernie
----- Original Message -----
From: "MikeB" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[EMAIL PROTECTED]>
Sent: Tuesday, August 24, 2004 2:17 PM
Subject: [RBG7-L] - SqlServer Connection String for DSN-Less Connection
> 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;
>
>