I have two different Sybase 12.0 DBs running on two physical machines(Solaris 8).I need to call a procedure on DB1 from windows 2k. The procedure on DB1 calls another procedure which is on a DB2(which is on a different physical machine). The procedure executes when i run it through Telnet, but fails when i use the query tool(AQT).
The syntax i'm using to connect to the inner procedure is servername.dbname..procedurename
Somebody please help solve the problem.