Thankz to both. Let me do something and get back.

Ajoy Khaund

Neamati Road

Near Bhogdoi Bridge

Jorhat 785001-21

Assam, India

Tel: 91-376-2351288

Cell: 91-94350-92287

Mail: akhaund@hotmail.com

Mail: akhaund@gmail.com

"Walking on water and developing software from a specification are easy if

both are frozen."

- Edward V. Berard, "Life-Cycle Approaches"

--------------------------------------------------

From: "Stephen Russell" <srussell705@gmail.com>

Sent: Friday, January 16, 2009 8:43 PM

To: <profoxtech@leafe.com>

Subject: Re: VFP and SQLServer 2005 Std Edition

> On Fri, Jan 16, 2009 at 8:19 AM, Ajoy Khaund <akhaund@gmail.com> wrote:

>> Stephen,

>>

>> Is ODBC the only way to connect to the sql server or is there any other

>> options.

>>

>> I am also new and I have installed sql server 2005 express edition.

>>

>> for odbc do I have to install a sql server odbc driver ???

>>

>> Plus I read there are two ways to go views & sql pasthrough. Which one

>> would

>> be easy for a desktop application. No web.

> ----------------------------------

>

> Rick summed it up pretty well.

>

> Yes you need the driver.

>

> You can do view or pass through or a combination. I personaly only

> did pass through but that was before cursor adapters were created. I

> have heard good things about their improvements but no hands on

> experience.

>

> --

> Stephen Russell

> Sr. Production Systems Programmer

> First Horizon Bank

> Memphis TN

>

> 901.246-0159

>

>

[excessive quoting removed by server]