Click to See Complete Forum and Search --> : Data Transformation Services
February 5th, 2000, 08:31 AM
I had 3 computers. 2 of them with Win 98 and one with Win NT4 Server. On all of them I installed SQL 7.0. I needed to transform Access 97 database into SQL. All my attempts failed on Win 98 computers (SQL Server freezes on DTS Wizard), but I could do that on Win NT. Recently I bought a new computer with Win 98 and tried to do the same task. Failure again. What can be wrong with SQL Server installation? Or maybe DTS doesn't work on Win 98? If so, why it doesn't give any messages? Just freezes.
Thank you.
Vlad
Dhirendra123
February 5th, 2000, 09:53 AM
I do not know whether SqlServer is supported on Windoes98 or not.
However, SQLServer is a database and should be installed on NT server ( and only at one machine). You can access the database from any computer ( Windoes95/98/NT ...even web) with program interface. You do not have to install SQLServer on all machine.
You will end up with lot of administration, maintananice and redudent data.
I would recommend to use NT server to host SQL Server
February 5th, 2000, 01:20 PM
Try to register the win98 Sql SErver on the NT machine and then export the DB to the Win 98 sql. DTS is touchy it seems that some of my databases transfer and some do not. MS has very many bugs within this tool. If service pack one is installed it will not work at all.
February 5th, 2000, 07:26 PM
Thank you.
I can do everything I want using my NT machine. My question was if DTS can work under 95/98. Either it's my bad installations or DTS doesn't work on all computers under 95/98? From another forum I just got the answer that although DTS installs it doesn't work under 95/98 and M$ stopped DTS under 95/98 (I did not understand the last part of that message)
Vlad
codeguru.com
Copyright Internet.com Inc., All Rights Reserved.