Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

DBCON does not connect at first

Former Member
0 Likes
415

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

2 REPLIES 2
Read only

Former Member
0 Likes
388

Hi Richard,

Can you paste the code?

Regards,

Atish

Read only

former_member182371
Active Contributor
0 Likes
388

Hi,

do have a look at OSS note 738371.

Best regards,