Here is a work around that usually fixes this problem.
1) Check in ODBC Data source Administrator (in Control Panel) what the driver version is for the GRTD_DSN.
The correct driver version is Sybase ASE ODBC Driver.
It is possible that there is a Microsoft Access Driver configured.
To change the driver version:
a) Click on GRTD_DSN and click Remove.
b) Click on Add to add a new DSN.
c) When the Create New Data Source screen pops up, scroll down and select the Sybase ASE ODBC Driver and click Finish.
d) The ODBC Sybase ASE Setup screen pops up. In the General tab enter the Data Source Name as GRTD_DSN. Enter the Server Name as GRTD_Server.
e) Click on the Connection tab. In the Server List field enter GRTD_SERVER.
f) Click Ok.
(2) Change the Server Address entry in dsedit:
a )Do a search for the filename dsedit.exe. Ensure that the path for the dsedit.exe file is ..\ASE12CLT\OCS-12_0\bin
b) Run dsedit and click Ok to open InterfacesDriver.
c) Change the Server Address for the Server Name GRTD_SERVER.
d) Double-click on Server Address.
e) Click Add.
f) In the Protocol box enter NLWNSCK.
g) In the Network Address box enter the IP address of the server and ",5000" (for example: xxx.xxx.xxx.xxx,5000).
h) Click Ok.
i) Close dsedit.
(3) If there is no Server Name GRTD_SERVER then add one as follows:
a) In dsedit, click Add in the Server Object drop down menu.
b) Enter the server name GRTD_SERVER and click Ok.
The Attributes and Values should read like this:
Server Entry Version 1
Server Name GRTD_SERVER
Server Service SQL Server
Server Status 4 Unknown