I have created 2 different applications using PowerBuiler 8.0. These applications connect to a Sybase SQL Anywhere 7 database via the same DSN connection.
The problem is that if the 2nd application is open, the 1st doesn't open (no-error reported). If I close the 2nd one, then the 1st suddenly opens. I believe it has something to do with database locking.
I have tried to use different DSN's (one for each application) but the problem remained.
hard to say whatz happening based on your description. If the second user is bounced, then most likley possibility is that you are using the desktop(single user) version of the SQL Anywhere(dbeng7) instead of dbsrv7.
I forgot to let you know that if I run the 1st application on say 6 PC's (in a network, 1 Database server) simultanously, no problem (since I am using dbsrv7). If I run the 2nd app on one of these and then try to open the 1st app on another PC, it cannot open. I mean it starts OK (I can see that in the Task Manager), it connects to the database (I can see it in the database server's Sybase Central), but when I try to login in the app (which is one SELECT script and two INSERT scripts), the next PB form that must appear does not open !
I see in the Sybase Central that the 1st app is "Blocked On" the second app and that the 1st app's last request was: Cursor Fetch (which means that the fetch never ended and it still tries ?). At this exact point, if I close the 2nd app, then the 1st app pops up ("Blocked On" becomes 0) and the PB form appears !
That's why I believe it is a lock of some kind. Any ideas ?