Do I need to load drivers to access SQL Server from a client machi

[Guest]

I am using the SQLClient data provider with a .NET Windows Foms app. I want
to connect to an instance of SQL Server from a client machine that does not
have SQL Server installed on it. What do I need to install on clients in
order to connect to the server? I am using Windows XP w/SP2. I am able to
make an ODBC connection to the server but not a connection through the
SQLClient provider.

Do I need to install the Client Connectivity drivers from the SQL Server
Enterprise CD on each client? Is there something else that is needed? Can I
use MSDE instead? Am I just missing something? I have looked all over the
place and I don't see anyone ever discuss this.

Thanks,
Matt

 

[Sahil Malik]

Do you have the .NET Framework installed on the client machine?


- Sahil Malik
http://codebetter.com/blogs/sahil.malik/

 

[Guest]

Yes. I have the .NET framework 1.1 with SP1 and the latest security update. I
am also running XP Pro with SP2 and all of the latest service packs.

 

[William \(Bill\) Vaughn]

When you deploy an .NET application, the .NET Framework and the MDAC stack
are deployed along with it. The DLLs used to access ADO.NET are included in
the Framework. I also expect that the MDAC stack is already loaded on your
system (as well might be the Framework). In many cases, your executable is
all that needs to be installed.

hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________