Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Hyukevain
Yak Posting Veteran
66 Posts |
 Posted - 2004-07-31 : 23:05:35
|
| Hello,Can anybody tell me where I can download MSDE for SQL Server 7 ? Because Microsoft web site apparantly only give link to SQL Server 2000 MSDE.Thank's |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-01 : 15:14:42
|
| ?????? Why would you want to??MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
Hyukevain
Yak Posting Veteran
66 Posts |
Posted - 2004-08-01 : 22:06:25
|
| We developed an client-server application that run DTS in SQL Server 7. To run DTS, we need DTSrun, but apparently we only get DTSRun file by installing SQL Server. If we run the DTSRun from server using xp_CmdShell, that mean the directory to store file generated by the DTS process will store in server (If we type "C:\" that's mean C:\ in server not in client, except we use the network address which we don't want to use).Is there any way for us to get the DTSRun file and it's library without installing SQL Server 7 ? My friend told me to use MSDE, but no MSDE for SQL Server 7, or is that possible that MSDE for 2000 version can be use with 7 version ? |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-01 : 22:36:58
|
| You just need to switch completely to using MSDE 2000. You can download it, and the latest service pack which you need to apply, at www.microsoft.com. Just go to the download area. That should have everything you need. I haven't used MSDE in so long, I'm assuming it has the DTSrun utility with it. ??MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
Hyukevain
Yak Posting Veteran
66 Posts |
Posted - 2004-08-04 : 04:17:16
|
| Access 2000 apparantly have some incompatibility issue with SQL Server 2000 somewhere in their function (we already tried to upgrade our db to 2000 version once but some problem start to raised, so we switch back)Is there any other way so we can have DTSRun and maybe BCP installed in client without have to install MSDE ? |
|
|
|
|
|
|
|
|
MSDE for SQL Server 7