Index
2008-12-23 05:23Rafael Copquin : Re: vfp and sqlserver express edition 2008 (first steps in VFP andSQLServer)
Back to top
Re: vfp and sqlserver express edition 2008 (first steps in VFP andSQLServer)

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]

©2008 Rafael Copquin