Hello,
PB 11.5, SQL Server 2012 Express, Windows Server 2012 R2 (in server) and Windows 7 (in clients)
Also SQL Server 2000 is there to view old data.
Every day at a particular time (between 3.00 to 3.30 pm), Powerbuilder application gets disconnected from client machines. Couldn't find out the reason so far.
Error Message:
-1
Select Error: SQLSTATE = 08502
Microsoft SQL Server Native Client 10.0
SMux Provider: Physical connection is not usable [xFFFFFFFF]
No scheduled backups is there [ in both SQL Servers].
No windows update is configured.
We couldn't find any programs that's running at that point of time.
When we ping the server from client at that time, response is normal. We could navigate the folders of the server from clients at that time, normally.
Only thing is PB application gets disconnected automatically, which runs smoothly when we re-run the application from start. Again it gets repeated next day.
Any idea how to proceed to find a solution ?
Happiness Always
BKR Sivaprakash
It's in a network environment. Connection drop happens in server too where SQL server is installed. When we re-run the application again, from start, everything works fine.