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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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.
__________________________________
 
Back
Top