Upgrade VB app from Win98 to Win2000

[VisuRao]

Hi,

I have a VB application that runs on Win98 using SQL Server 7.0 database and some third pary controls like Apex true DB Grid, List etc. The app also using Crystal Reports 7.0. I need to upgrade this app to run on Win2000 with SQL Server 2000 database and Crystal Reports 8.5. Can anybody suggest what all the important things I should look into to do this? Is there any article available here (or anywhere in the web) that discusses this issue? It would be a great help for me. Thanks in advance.

~Visu

 

[vududoc]

VisuRao,

You say that you are changing O/S from Win98 to Win2000, changing the database from SQLServer v7 to SQLServer v2000 and reports from Crystal Reports v7 to v8.5 !! The apps probably were also compiled in Win98 with ADO2.5 which, when compiled in Win2000, will become ADO2.7

May I suggest a cautious stepwise approach to reduce the number of varibles you have to look at to solve problems encountered?

You can estimate 1 work week per step, but this will depend on the size/complexity of the VB application. I suggest you create test scripts and have the users (knowledgable of how the application should work) test it -- marking the scripts where problems are encountered.

Setup a test system, and test the VB application first in Win98 then upgrade to Win2000 using a truncated SQLServer7 database and only one or two of your Crystal Reports v7 reports. If you have to make changes in the VB app, recompile it on the OLD Win98 machine, and retest.

Once these problems are resolved, upgrade the database to SQLServer 2000. When these problems are resolved, then upgrade Crystal Reports and resolve these problems. Once everything is working, recompile your VB application in Win2000, and resolve the ADO problems.

Several years ago I tested VB6/Oracle8 and VB6/Access97 applications (compiled with ADO2.5 on winNT) on win2000 machines. They did NOT use 3rd-party components. I encountered NO problems.

Good luck!

 

[VisuRao]

vidudoc,

Thank you very much for your suggestions.

~Visu