|
| I have a application which connected to sybase9 database TESTDB. Everything
works fine before. Recently, I add a trigger in sybase9 TESTDB to call a
proxy table which connect to a remote table in sybase5 through remote
server. When I insert a record to TESTDB table it will also run the trigger
to insert to sybase5 table.
I have tested the remote server using test connection in sybase central, it
shows "connecting successful". I test the proxy table by using view data in
interactive sql, it also work normally. I even run the insert to TESTDB
script in ISQL. It insert a record to TESTDB table, it also insert a record
to sybase5 through remote server. Seems everything works fine.
But when I run the application I always got message "Native: -659 Message:
[Sybase][ODBC Drive][Adaptive Server Anywhere]
Remote server 'test' could not be found; Add the server using CREATE
SERVER".
Anybody have this problem before? Do I need set connection to remote server
in application exception in sybase9 central?
Thans,
Lyn
|
|