Solved

Vb.net Application with SQL Connection over a LAN

Posted on 2008-10-17
7
629 Views
Last Modified: 2013-11-26
I have an application that resides on a LAN and has connections to a SQL database.  Obviously, on the development machine all connections work fine (sql server is loaded).  I need to know what all of the other client machines need to have on them so the connection will work when they use the application.

Clients consist of both XP and Vista (32 and 64 bit) operating systems.

Thanks for your help
0
Comment
Question by:toddpotter
  • 3
  • 2
  • 2
7 Comments
 
LVL 16

Accepted Solution

by:
ororiole earned 500 total points
ID: 22746682
You didnt mention that version of sql server you are using. Lets assume its 2005 or earlier. If you are using 2008 you will find the links to it on one of these pages as well.
asically, if you are not using advanced features like reporting or notification services, you will need
Sql Server Native Client
MSXML 6.0 (only for XP. Vista comes with this).

To get native client go here, http://www.microsoft.com/downloads/details.aspx?FamilyId=50b97994-8453-4998-8226-fa42ec403d17&DisplayLang=en scroll about halfway down and look for Sql Server Native Client. There you can select to download the x86 (32 bit) and x64 packages.

For MSXML 6.0 go here: http://www.microsoft.com/downloads/details.aspx?FamilyID=d21c292c-368b-4ce1-9dab-3e9827b70604&displaylang=en
and select from the x86 and x64 packages. You need MSXML 4.0 also but this will install both.
0
 
LVL 13

Expert Comment

by:TechTiger007
ID: 22747437
If your application is console application or winforms then the clients should install dotnet framework on their machine
0
 

Author Comment

by:toddpotter
ID: 22747587
SQL Server 2000 is the version.

All of our XP Clients (rouhly 50) have the .net framework 1.1 and no sql client installed and the app works fine.  We have one Vista 32-bit client and he has mySql installed and his works fine.  The Vista 64-bit client  has the .net framework 2.0 and does not have any mySql, sql client or anything of that nature installed.  The app does not work on this machine.  
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 
LVL 13

Expert Comment

by:TechTiger007
ID: 22747972
Your application is developed in dotnet  framework 1.1 so you should have framework 1.1  installed in the machine to run this application. framework 2.0 cannot run applications developed with framework 1.1.
0
 

Author Comment

by:toddpotter
ID: 22748146
On the Vista machine I just installed .net Framework 3.5 and SQL Server Express 2008 client.  The machine now works so there was obviously some sort of SQL connectivity issue.
0
 
LVL 13

Expert Comment

by:TechTiger007
ID: 22756570
Was framework 1.1 already installed?
0
 
LVL 16

Expert Comment

by:ororiole
ID: 22762750
It needed the sql client in order to talk to the server. Now that it is installed, it works. :)
0

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

Suggested Solutions

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now