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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQL 7 to SQL2000 application problems

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-04-21 : 20:55:03
Damian writes "Hi,

We have currently been developing an application using SQL7 with great results. We are obviously using the SQL7 client on the machines that are connecting to the database and they work fine.

We have just started looking at SQL2000 and have come across a show stopping problem, that is, when the SQL2000 client is used to connect to the database it does not work properly. We have found that when using ADO to connect to the database, if it runs across a table that is empty it will give us an EOF or BOF error message. From that point on the application will not work at all, and therefore needs to be restarted in order to correct the problem.

I am after any information about design changes that may cause this sort of problem to occur.

Thanks
Damian"
   

- Advertisement -