Sybase protocol driver failed

Error Message:
---------------------------
Warning
---------------------------
[SYBASE][ODBC Sybase driver][Sybase]ct_connect(): user api layer: internal Client Library error: Read from the server has timed out.[SYBASE][ODBC Sybase driver][Sybase]ct_connect(): network packet layer: internal net library error: Net-Lib protocol driver call to connect two endpoints failed

Possible Cause:
Usually caused by an open client problem. This is conectivity problem.

Resolution:
use dsedit to check the connection string for the desired server entry.
if the server does not exist, add the connection info

OR

Check sybase open client location
go to environtment system variable
check on the value of variable SYBASE
or

go to command prompt
type: echo %SYBASE%

open %SYBASE%\INI\sql.ini
add conection entry for the desired server
[SybaseASEName]
query=protocol,hostname,sybase_port_number_on_hostname
master=protocol,hostname,sybase_port_number_on_hostname

example :
sybase server instance name is : local_001
hostname for local_001 is server_001
port number used for sybase in server_001 is 5000
protocoll used is WINSOCK (NLWNSCK)

the entry is as follow:
[local_001]
query=NLWNSCK,server_001,5000
master=NLWNSCK,server_001,5000

Sybase - ReCreating SYB_BACKUP server

01. Stop Backup Service. i.e. Sybase SQLServer_[ASE]_BS.
02. Remove Backup Server using Server Config ($SYBASE\ASE-12_5\BIN\SYCONFIG.exe).
03. Remove file "Run_[ASE]_BS.bat". Or renamed it to "Run_[ASE]_BS.bat.orig".
04. Remove Backup Server mapping from master..sysservers using sp_dropserver SYB_BACKUP command.
05. Stop SQL Service i.e. Sybase SQLServer_[ASE].
06. Restart Machine.
07. Start SQL Service. Backup service is still exist in the "Services" window.
08. Remark Backup Server entries in $SYBASE\ini\SQL.ini or delete them.
09. Create Backup Server using Server Config.
10. Check SQL.ini. There should be new entries created for Backup Server. Ping it using DSEDIT utility ($SYBASE\OCS-12_5\BIN\DSEDIT.exe).
11. Insert SYB_BACKUP server into master..sysservers table by running below script. Must be 'sa' or user with 'sa_role' to run it.
12. Test Dump master DB.
13. When failed, excalate the issue.

Related Links :
www.sybase.com
www.sypron.nl

Terms :
ASE stands for Adaptive Server Enterprise. It is practically the Sybase Server Instance

Sybase - Bind tempdb

Sybase - Bind tempdb

• bind a tempdb to a particular application / program
  sp_tempdb 'bind','AP','','DB','TEMPDB4'
  
• bind a tempdb to a particular login name
  sp_tempdb 'bind','LG','','DB','TEMPDB2'