System.Data.SQLClient Question

  • Thread starter Thread starter Buddy
  • Start date Start date
B

Buddy

Hello,

I have two machines a server and a workstation, I've
installed SQL Server 2000 on the SERVER pc, will I need to
all install SQL Server 2000 Client on the workstation
machine for me to use the System.Data.SQLClient functions.

Can someone point me to any documentation stating this.

Thanks
 
You only need to install the .NET Framework on the client computers.
The .NET Framework includes the drivers to access SQL Server DataBases
 
Thanks for the reply, but would you know where I can find
some evidence to prove this.

Thanks,
 
Thanks for the reply, but would you know where I can find
some evidence to prove this.
Click to expand...

just write a simple code, run it and see the proof by your own eyes.
 
Thanks for your lovely comment, I need an quick answer,
which is the reason I have not done this. For me to do
this I would need a clean machine that has never had SQL
Server 2000 Client installed, currently I do not have a
machine like that, so I was hoping for someone to point me
to the right direction with some documentation.

Thanks
 
Lol, look just take it from us ok ;)

Kieran

Buddy said:
Thanks for your lovely comment, I need an quick answer,
which is the reason I have not done this. For me to do
this I would need a clean machine that has never had SQL
Server 2000 Client installed, currently I do not have a
machine like that, so I was hoping for someone to point me
to the right direction with some documentation.

Thanks
Click to expand...
 
This article

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_8lmb.asp

indicates that the SQL Client is installed by MDAC (Its already on all PC's for the most part. MDAC 2.7 is installed on XP and win 2003 servers, 2.5 is installed on Win 2000)

And the framework requires MDAC 2.7 be installed. per when you install the framework (Pre-requisites)

By the way MDAC 2.8 is now available as well...

http://www.microsoft.com/downloads/...e3-c795-4b7d-b037-185d0506396c&DisplayLang=en

Is this what you were looking for?

Scot Rose, MCSD
Microsoft Visual Basic Developer Support
Email : (e-mail address removed) <Remove word online. from address>

This posting is provided “AS IS”, with no warranties, and confers no rights.

Get Secure!
http://www.microsoft.com/security
http://www.microsoft.com/protect


--------------------
 
Back
Top