CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4
  1. #1
    Guest

    Data Transformation Services

    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


  2. #2
    Join Date
    Dec 1999
    Posts
    20

    Re: Data Transformation Services

    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


  3. #3
    Guest

    Re: Data Transformation Services

    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.


  4. #4
    Guest

    Re: Data Transformation Services

    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


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured