Most common connection method to SQL 2005

I am currently using ADO from an application to connect to SQL 2005. Is this
the preferred way, or is that the most common method? I was told I need to
use an API. Which API? Thanks.

Charlie

Re: Most common connection method to SQL 2005

>I am currently using ADO from an application to connect to SQL 2005. Is
>this the preferred way, or is that the most common method?

It depends on your development language and environment. From modern .NET
languages, ADO.NET is both the most common and preferred method.

> I was told I need to use an API. Which API? Thanks.

I'm not sure what was meant by that statement. ADO and ADO.NET are APIs,
albeit higher-level ones compared with OLEDB and ODBC. Perhaps we can offer
some suggestions if you provide more details of your environment.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Charlie" wrote in message
news:46b65a42$0$31216$4c368faf@roadrunner.com...
>I am currently using ADO from an application to connect to SQL 2005. Is
>this the preferred way, or is that the most common method? I was told I
>need to use an API. Which API? Thanks.
>
> Charlie
>