all groups > sql server msde > october 2006 >
You're in the

sql server msde

group:

SQL Sever 2005 Express Client Question


SQL Sever 2005 Express Client Question Joel
10/11/2006 7:48:54 AM
sql server msde:
I downloaded and installed SQL server 2005 Express onto a Win XP Pro
Computer. If I want to access the database from another computer what
client do I install on the 2nd computer? (In 2000 it was the Client Network
Utility but I am not sure how to do it now).

Thanks

Re: SQL Sever 2005 Express Client Question Andrea Montanari
10/11/2006 6:16:55 PM
hi Joel,
[quoted text, click to view]

if you mean "what APIs" you should deploy, you can safely use MDAC, quiet
included and upgraded for each OS flavour, or the Native Client of the .Net
framework as well... you can even deploy the SQL Server Nativ Client at .Net
Fwk 2.0..
"..
Microsoft SQL Server Native Client (SQL Native Client) is a single
dynamic-link library (DLL) containing both the SQL OLE DB provider and SQL
ODBC driver. It contains run-time support for applications using native-code
APIs (ODBC, OLE DB and ADO) to connect to Microsoft SQL Server 7.0, 2000 or
2005. SQL Native Client should be used to create new applications or enhance
existing applications that need to take advantage of new SQL Server 2005
features. This redistributable installer for SQL Native Client installs the
client components needed during run time to take advantage of new SQL Server
2005 features, and optionally installs the header files needed to develop an
application that uses the SQL Native Client API.
..."

http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en

the SQL Server 7.0 and 2000 Client Network Utility is just a "client" tool
to manage what kind of network protocol(s) should be used to connect to
remote SQL Server (7.0 and 2000) instances, and is included in the MDAC
stack..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
--------- remove DMO to reply

AddThis Social Bookmark Button