System.Data.SQL Client Question

[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.SQL Client functions.

Can someone point me to any documentation stating this.

Thanks

[Dan Cimpoiesu]

You only need to install the .NET Framework on the client computers.
The .NET Framework includes the drivers to access SQL Server DataBases

"Buddy" <Bu***@Onlinewo rk.com> wrote in message
news:07******** *************** *****@phx.gbl.. .

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.SQL Client functions.

Can someone point me to any documentation stating this.

Thanks

[Buddy]

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

Thanks,

-----Original Message-----
You only need to install the .NET Framework on the client computers.The .NET Framework includes the drivers to access SQL Server DataBases
"Buddy" <Bu***@Onlinewo rk.com> wrote in message
news:07******* *************** ******@phx.gbl. ..

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.SQL Client functions.
Can someone point me to any documentation stating this.

Thanks

.

[Wiktor Zychla]

> Thanks for the reply, but would you know where I can find

some evidence to prove this.

just write a simple code, run it and see the proof by your own eyes.

[Buddy]

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

-----Original Message-----

Thanks for the reply, but would you know where I can find some evidence to prove this.
just write a simple code, run it and see the proof by

your own eyes.

.

[Kieran Benton]

Lol, look just take it from us ok ;)

Kieran

"Buddy" <Bu***@Onlinewo rk.com> wrote in message
news:05******** *************** *****@phx.gbl.. .

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

-----Original Message-----

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

just write a simple code, run it and see the proof by

your own eyes.

.

[Scot Rose [MSFT]]

This article

http://msdn.microsoft.com/library/de...stsql_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/d...DisplayLang=en

Is this what you were looking for?

Scot Rose, MCSD
Microsoft Visual Basic Developer Support
Email : sc***@online.mi crosoft.com <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
--------------------

Content-Class: urn:content-classes:message
From: "Buddy" <Bu***@Onlinewo rk.com>
Sender: "Buddy" <Bu***@Onlinewo rk.com>
References: <07************ *************** *@phx.gbl> <ue************ **@TK2MSFTNGP12 .phx.gbl>
Subject: Re: System.Data.SQL Client Question
Date: Thu, 11 Sep 2003 04:37:00 -0700
Lines: 29
Message-ID: <04************ *************** *@phx.gbl>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Thread-Index: AcN4WQNtgcGqZWp GTYqrj3i0uh/70g==
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Newsgroups: microsoft.publi c.dotnet.langua ges.csharp
Path: cpmsftngxa06.ph x.gbl
Xref: cpmsftngxa06.ph x.gbl microsoft.publi c.dotnet.langua ges.csharp:1840 20
NNTP-Posting-Host: TK2MSFTNGXA08 10.40.1.160
X-Tomcat-NG: microsoft.publi c.dotnet.langua ges.csharp

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

Thanks,

-----Original Message-----
You only need to install the .NET Framework on the client

computers.

The .NET Framework includes the drivers to access SQL

Server DataBases

"Buddy" <Bu***@Onlinewo rk.com> wrote in message
news:07****** *************** *******@phx.gbl ...

Hello,

I have two machines a server and a workstation, I've
installed SQL Server 2000 on the SERVER pc, will I needto all install SQL Server 2000 Client on the workstation
machine for me to use the System.Data.SQL Clientfunctions.
Can someone point me to any documentation stating this.

Thanks

.