Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
logie0726
Starting Member
17 Posts |
 Posted - 2008-09-30 : 05:19:57
|
Here is the situation: We are using Sql server 2000 and PowerBuilder 5.0.02 and im using the powerbuilder and encoding lots of entry, I did not Update or press Save yet. Then the connection from Lan Fails! I Cannot save my work and need to log-in again from powerbuilder. Is it possible that even the connection fails i do not have to log-in and lost the connection? Thanks!  |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-09-30 : 05:57:38
|
If connection is lost, all work is saved upto last statement that run successfully.If you were running a statement during loss of connection, that statement is rolled back.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
logie0726
Starting Member
17 Posts |
Posted - 2008-09-30 : 07:16:02
|
| Thanks for the reply Peso..Sample: I'm using Query Analyzer and Powerbuilder at the same time using WIFI connection. When the connection to the Server lost, then connect again...SQL Query analyser - No need to log-in again and restores the connectionPowerbuilder - Needs to Log-in and lost the data I'm encoding.I just want to know is it possible to resume the connection from PB to SQL without losing the data! Just like the SQL ANALYZER |
|
|
|
|
|
|
SQL AND POWERBUILDER CONNECTION