|
Home > Archive > SQL Anywhere database > July 2005 > Long connection duration
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Long connection duration
|
|
|
| My PB program sometimes takes about 20 seconds to make
database (ASA) connection, but sometimes only take 1 to 2
seconds to make connection. Why ? Please advise.
Connection Parameters :
SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm =
" ConnectString='DSN=E
RS;CharSet='cp950';C
ommitOnDisconnect=No
'
,ConnectOption='SQL_
DRIVER_CONNECT,SQL_D
RIVER_NOPROMPT'"
PB version : 7.0.3
ASA version : 8.0.2 (ebf 4361)
| |
| Paul Horan[TeamSybase] 2005-07-28, 7:23 am |
| <Ken> wrote in message news:42e84821.4707.1681692777@sybase.com...
> My PB program sometimes takes about 20 seconds to make
> database (ASA) connection, but sometimes only take 1 to 2
> seconds to make connection. Why ? Please advise.
>
> Connection Parameters :
> SQLCA.DBMS = "ODBC"
> SQLCA.AutoCommit = False
> SQLCA.DBParm =
> " ConnectString='DSN=E
RS;CharSet='cp950';C
ommitOnDisconnect=No
'
> ,ConnectOption='SQL_
DRIVER_CONNECT,SQL_D
RIVER_NOPROMPT'"
>
> PB version : 7.0.3
> ASA version : 8.0.2 (ebf 4361)
If you don't have the "ERS" ODBC profile pre-defined with the TCPIP protocol settings, then try adding
LINKS=TCPIP{HOST=xx.xx.xx.xx} into the connectstring dbparm.
--
Paul Horan[TeamSybase]
| |
|
| I have already defined the "ERS" ODBC profile in ODBC
(System data source). But it takes long time to make
connection.
you don't have the "ERS" ODBC profile pre-defined with
> the TCPIP protocol settings
> <Ken> wrote in message
> 2 seconds to make connection. Why ? Please advise. >
> ,ConnectOption='SQL_
DRIVER_CONNECT,SQL_D
RIVER_NOPROMPT'" >
>
> If you don't have the "ERS" ODBC profile pre-defined with
> the TCPIP protocol settings, then try adding
> LINKS=TCPIP{HOST=xx.xx.xx.xx} into the connectstring
> dbparm.
>
> --
> Paul Horan[TeamSybase]
>
>
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-07-28, 9:23 am |
| How have you defined the DSN? Paul was suggesting that you define the DSN
such that you force the connection using TCPIP and specify the IP address of
the machine where the server is running.
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL
<Ken> wrote in message news:42e8d54b.308a.1681692777@sybase.com...[color=darkred]
> I have already defined the "ERS" ODBC profile in ODBC
> (System data source). But it takes long time to make
> connection.
> you don't have the "ERS" ODBC profile pre-defined with
|
|
|
|
|