Is there a legal, and free, way to download the SQL 2000 database connectivity tools for free? Our company is about to start using a software package, that requires the connectivity tools in SQL, but we don't have enough licenses to go around (we will need at a minimum 24). The connectivity tools only take a second to install, and, at least in my mind, should be free. If anyone can help me out, that would be greatly appreciated. I posted something like this earlier, but when I did a search for my post, I couldn't find it. Thanks for any help.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Can SQL 2k connectivity tools be downloaded?
- Thread starter tokuzumi
- Start date
tlbroadbent
MIS
The only connectivity tools that are available for free are the Microsoft Data Access Components (MDAC). Is that what you need? These can be obtained from the Miscrosoft website.
If you want the SQL client tools such as Enterprise Manager and and Query Analyzer, you'll have to purchase SQL Server. These administrative tools are not available for free. Your previous post was probably deleted because someone felt it was inappropriate for these forums. We don't want to help people pirate software. If SQL client tools were available for download you could go to the vendor site to get them just as you can MDAC. Terry L. Broadbent - DBA
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
If you want the SQL client tools such as Enterprise Manager and and Query Analyzer, you'll have to purchase SQL Server. These administrative tools are not available for free. Your previous post was probably deleted because someone felt it was inappropriate for these forums. We don't want to help people pirate software. If SQL client tools were available for download you could go to the vendor site to get them just as you can MDAC. Terry L. Broadbent - DBA
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
- Thread starter
- #3
we have tried just mdac, and that doesn't seem to fix our problem. Now, on our version of SQL (enterprise developer), we have three install options.
1. Install Database Server
2. Client Tools
3. Connectivity Only
We need option number three. All it does, is install MDAC components, and some other files. What I want to know, is if whatever option 3 does, can be downloaded, from Microsoft, LEGALLY, for free. I hope that helps.
1. Install Database Server
2. Client Tools
3. Connectivity Only
We need option number three. All it does, is install MDAC components, and some other files. What I want to know, is if whatever option 3 does, can be downloaded, from Microsoft, LEGALLY, for free. I hope that helps.
tlbroadbent
MIS
What is the problem? Why do you need to download something when you have the CD? The connectivity-only option installs Network Libraries and MDAC. You can freely install it on all clients from the CD or place it on a network location for installtion. Terry L. Broadbent - DBA
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
- Thread starter
- #5
The problem is the disk resides at our location, and the people who are going to be using the software are going to be located all across the country, and not be physically able to get their hands on the disk.
Would we run into any issues, as when I select the Connectivity Only option, it still asks me for the CD Key. We can't just put the key in a notepad document, and place it up on the server. But it is okay to put the files on a network drive, for the users to download, and install on their local machines? That's definately a step in the right direction. Thanks for your help so far. Keep the responses coming.
Would we run into any issues, as when I select the Connectivity Only option, it still asks me for the CD Key. We can't just put the key in a notepad document, and place it up on the server. But it is okay to put the files on a network drive, for the users to download, and install on their local machines? That's definately a step in the right direction. Thanks for your help so far. Keep the responses coming.
tlbroadbent
MIS
What do they need in addition to MDAC? We install MDAC on thousands of computers and they access SQL Server data using a variety of software. None of them used the Connectivity Tools installation. Terry L. Broadbent - DBA
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
- Thread starter
- #7
We are not sure, either. When we don't use the SQL connectivity only tools, we have problems with the software. When we use the SQL software, we have no problems. Even the reps from the software company didn't know what their software requires from SQL server (these weren't programmers. They were "Technology Managers"
. I had just created a system DSN, and we were able to get some functionality out of it, but there were a few problems using the software. That's why we need to get the connectivity tools out to the users of the software, but giving them the disk is not an option for us. How can we get this up on our network, so the people who need the SQL connectivity tools, can get them, and install them? Thanks.
. I had just created a system DSN, and we were able to get some functionality out of it, but there were a few problems using the software. That's why we need to get the connectivity tools out to the users of the software, but giving them the disk is not an option for us. How can we get this up on our network, so the people who need the SQL connectivity tools, can get them, and install them? Thanks.
tlbroadbent
MIS
Check the following link. It expalins how to distribute the SQL Connectivity using the "sqlredis Software Distribution Executable."
Terry L. Broadbent - DBA
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
Terry L. Broadbent - DBA
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
