Most common connection method to SQL 2005

#1

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

#2

Quote:

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.

Quote:

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" <jadkins4 (AT) yahoo (DOT) com> wrote

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Most common connection method to SQL 2005

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Most common connection method to SQL 2005 - 08-05-2007 , 06:16 PM

Re: Most common connection method to SQL 2005 - 08-07-2007 , 10:49 PM