Author: Rafael Copquin
Posted: 2008-12-23 05:23:44 Link
My apologies for the delay in answering this one, but I had been using my
notebook and this email entered via my desktop and just read it today.
> Hope this helps.
Yes, it does, thank you and Merry Christmas (extended wish to all of you
profoxers!)
Rafael Copquin
----- Original Message -----
From: "Stephen Russell" <srussell705@gmail.com>
To: <profoxtech@leafe.com>
Sent: Wednesday, December 17, 2008 9:10 PM
Subject: Re: vfp and sqlserver express edition 2008 (first steps in VFP
andSQLServer)
>
> Some people like DSN, I like a good Text string myself.
>
> http://www.connectionstrings.com/sql-server-2005
>
> This will determine how you could or would use any of the 15-20
> different versions of connection to a SQL Server db.
>
> Standard security
> Driver={SQL Native Client};Server=myServerAddress;Database=myDataBase;
> Uid=myUsername;Pwd=myPassword;
>
> Are you using SQL Server 2005 Express? Don't miss the server name
> syntax Servername\SQLEXPRESS where you substitute Servername with the
> name of the computer where the SQL Server 2005 Express installation
> resides.
>
>
> Trusted Connection
> Driver={SQL Native Client};Server=myServerAddress;Database=myDataBase;
> Trusted_Connection=yes;
> Equivalent key-value pair: "Integrated Security=SSPI" equals
> "Trusted_Connection=yes"
>
> Hope this helps.
>
> --
> Stephen Russell
> Sr. Production Systems Programmer
> Mimeo.com
> Memphis TN
>
> 901.246-0159
>
>
[excessive quoting removed by server]