The SQL Native client dlls are needed by the SQL Server 2005
Command Line Query Utility. SQL Native client is a data
access component - it combines the ODBC driver and OLE DB
provider functionality and includes support for the new
features in SQL 2005. So it's more like an ODBC driver or an
OLE DB provider.
The Command Line Query Utility has the exec - sqlcmd. Sqlcmd
is like executing isql or osql from the command line. So
it's not like Query Analyzer. SQL Server Management Studio
is the tool in 2005 that combined Enterprise Manager and
Query Analyzer. Whether you can install that or not depends
on what type of licensing you have for your SQL Server 2005
box. The SQL Server Management Studio is installed from your
SQL Server media. You can install just the Workstation
components.
Other tools that can be used to manage SQL Server are listed
in the following article:
http://sqlserver2000.databases.aspfaq.com/how-do-i-manage-sql-server/msde.html
-Sue
On Mon, 11 Jun 2007 10:20:23 -0400, "Miaohua Xu"
[quoted text, click to view] <vince_xu@hotmail.com> wrote:
>Is SQL Native Client to SQL Server 2005 similar as Query Analyzer to SQL
>Server 2000? I downloaded sqlncli.msi but it doesn't include any .exe, cmd
>or bat file. It does have some dll files. Are the dll files needed by
>sqlcmd?
>
>Thanks,
>Vince
>
>
>"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
>news:72hp63huiu2aqtniiehdps5aa2i74mpl4e@4ax.com...
>> The client can connect to SQL Server using what?
>> One option is just connect using sqlcmd and execute sql
>> statements. You can download this from the Feature Pack
>> downloads - check the Microsoft SQL Server 2005 Command Line
>> Query Utility download:
>>
http://www.microsoft.com/downloads/details.aspx?familyid=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&displaylang=en >>
>> That and the SQL Native Client are all that would be needed.
>>
>> -Sue
>>
>> On Sat, 9 Jun 2007 17:52:02 -0400, "Miaohua Xu"
>> <vince_xu@hotmail.com> wrote:
>>
>>>Hi,
>>>
>>>A SQL Server 2005 is already running fine in one computer (WinXP) and now
>>>I
>>>need to install client in another one(Win XP). What I need is very simple:
>>>the client can connect to the server and execute some sql command. Is SQL
>>>Native Client supposed to do this or not? Where can I find such a client?
>>>
>>>Thanks,
>>>Vince
>>>
>>
>
