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