ASAP
Hi All,
I have a strange problem about connection to the server. I build an
application using PowerBuilder 6.5 and Sybase 11.9.2.
The OS is Windows NT 4. I have more than 10 users that using my application.
The problem is when the user run the application and connect/login to the
server, in Processes directory (in Sybase SQL Central) there are several
login ID for one Login ID (user). In fact, only one login ID for one user
that run an application. I really confuse because everytime my user run my
application, it always happen.
Here my script :
Script for connection to the server :
SQLCA.DBMS = ls_dbms
SQLCA.DataBase = ls_dbname
SQLCA.LogId = ls_logid
SQLCA.LogPass = ls_logpass
SQLCA.ServerName = ls_servername
SQLCA.UserId = ls_logid
SQLCA.DBPass = ls_logpass
SQLCA.Lock = "0"
SQLCA.DBParm = ""
// If can't connect, display message...
CONNECT Using SQLCA;
IF SQLCA.SQLCode <> 0 THEN
MessageBox("Database Connect","Unable to connect database " + ls_dbname +
"." + &
" DB Error Code : " + String (SQLCA.SQLDBCode) + " - " + &
SQLCA.SQLErrText, StopSign!, OK!, 1)
HALT Close
END IF
Script for disconnect :
If SQLCA.DBHandle() > 0 Then
DISCONNECT Using SQLCA;
IF SQLCA.SQLCode <> 0 THEN
MessageBox("Database Disconnect","Unable to disconnect database." + &
" DB Error Code : " + String (SQLCA.SQLDBCode) + " - " + &
SQLCA.SQLErrText, StopSign!, OK!, 1)
End If
END IF
Can anyone help me to solve my problem ?
Regards,
Rendy Theixar
PT. Surabaya Agung Industri Pulp & Paper, Tbk
E-mail : [EMAIL PROTECTED]
URL : http//www.suryakertas.com
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
