I am running VB6. I have a SQL server 7.0.

I have loaded MDAC 2.5 and I have connected using ADO data Controls. I have tried using ODBC drivers, Microsft SQL Server drivers but it takes 1.5 to 2 seconds sometimes to move from one record to the next. Since I am converting from Access97 to SQL server, I still have the data in an Access97 database. I can connect to the access97 database using VB6 and it is very fast.

My conclusion is that either the network protocol used to communicate with SQL server is slower than IPX/SPX or the SQL server is slow.

Server memory 96 meg RAM.

QUESTION:

When i go into SQL Enterprise Manager, it takes a few seconds to connect. It then takes about 2 seconds to get to the database directory. I can then move to the Views area and look at the exact same view that I am using in the VB6 data control. When I open the view and ask to see all records, it takes about 5 seconds before I get to the view screen. I can then watch the data roll down the screen and it takes a good 30 seconds to finish. Is this Normal for enterprise manager?