2007 Nov 09 1:51 AM
I've setup a connection to SQL Server. When I ran one program that connects it fails , not finding the sql table to delete because the connection failed with a rtn=4. Then, I run my other program that connects to SQL Server and it works. So I try my previous program and it now runs.
In fact, for the last 3 nights the programs have run OK, now suddenly they don't connect at first. Then do.
Does anyone have any ideas. Should I loop till it connects ?
Any ideas will be rewarded!
Thanks,
Richard
I've setup a connection to SQL Server. When I ran one program that connects it fails , not finding the sql table to delete because the connection failed with a rtn=4. Then, I run my other program that connects to SQL Server and it works. So I try my previous program and it now runs.
In fact, for the last 3 nights the programs have run OK, now suddenly they don't connect at first. Then do.
Does anyone have any ideas. Should I loop till it connects ?
Any ideas will be rewarded!
Thanks,
Richard
2007 Nov 09 2:15 AM
2007 Nov 09 6:07 PM