Hi Guys,
I got a problem with ADO components. I've got a little program running on a server which does updates certain records to another sql server if certain conditions are met. That works fine, without any problem. The problem comes in when the connection fails (due to the other server being off), any reconnection to that server fails, even though the server is back on. Only restarting the application works. I created a test application which tests this theory : if a ADO component (ADOQuery) tries to connect and it fails, then it won't reconnect until I restart the application. On the other hand if I replace the components with BDE components then it reconnects fine after it loses the first connection. Is this a bug in the ADO components ? Unfortunately I need to use ADO and can't use BDE (customer specs). Any ideas ?
I got a problem with ADO components. I've got a little program running on a server which does updates certain records to another sql server if certain conditions are met. That works fine, without any problem. The problem comes in when the connection fails (due to the other server being off), any reconnection to that server fails, even though the server is back on. Only restarting the application works. I created a test application which tests this theory : if a ADO component (ADOQuery) tries to connect and it fails, then it won't reconnect until I restart the application. On the other hand if I replace the components with BDE components then it reconnects fine after it loses the first connection. Is this a bug in the ADO components ? Unfortunately I need to use ADO and can't use BDE (customer specs). Any ideas ?