I have just upgraded an application that our company wrote from RDO to ADO. The application is a VB front end to a SQL server 7.o database. There are only 4 clients that connect to the machine so the number of users is very low.
The problem is, since I have re-written the application to use ADO rather than the old RDO I am now getting lots of 424 object not found errors. These errors are quite random. You can repeat the same operation in the code and one minute the error is there, the next time you do the same thing there is no error.
Does anyone have any ideas why this is or what I can do to stop this? Will installing SP 4 resolve this issue? Or is it more of a network issue with timeouts?
P.S The application runs fine on our development network so it is not our coding!!!
Thanks for your help
Kev
The problem is, since I have re-written the application to use ADO rather than the old RDO I am now getting lots of 424 object not found errors. These errors are quite random. You can repeat the same operation in the code and one minute the error is there, the next time you do the same thing there is no error.
Does anyone have any ideas why this is or what I can do to stop this? Will installing SP 4 resolve this issue? Or is it more of a network issue with timeouts?
P.S The application runs fine on our development network so it is not our coding!!!
Thanks for your help
Kev