Sybase openserver setup

Sybase openserver(for SQL REMOTE) setup:

 

1、create a stable database,named SRV..QUEUE

2、Run following scripts:

   stableq.sql

   squpdate.sql

3、Create connection to SRV..QUEUE in RSP,and then delete the connection just created

4、Start OpenServer

e:\sybase\bin\ssqueue.exe -c eng=OHQ;dbn=Prim_DB;uid=DBA;pwd='' -cq eng=OPServer;dbn=Queue_DB;uid=DBA;pwd=''  -os 4M -v -k -o e:\Logs\OpenServer.log DBServerName

5、Change procedure CHAIN MODE

   sp_procxmode Proc_name,chained

6、Create connection to DBServerName..QUEUE

7、Run ssremote.rs in rsp