on 2012 Aug 14 9:49 AM
Current installation of SQL Anywhere 9.0.2.3951 on Win 2k3 with a remote server on a MSSQL with no problems. We moved the SQL Anywhere DB a new server, Win 2k8R2. Now, when acessing the MSSQL remote server proxy tables are working, but when executing remote procedure, MSSQL return 'procedure x not found'. I deleted and recreated the remote server and remote login. When creating the proxy for the remote procedure (with Sybase Central) I see the list of stored proc on the MSSQL DB. How can I see a list of remote procs, but when executing the proxy the I get an error with the remote proc not found.
Any help appreciated.
Request clarification before answering.
Besides my comments on your question, I would try to use Remote Data Access debugging (i.e. using CIS_OPTION = 7), cf. this v12.0.1 doc page...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
With the CIS_OPTION and trace, the only thing that was different between the two setup was the version of sqlsrv32.dll. Everything worked once I used the same driver version.
User | Count |
---|---|
96 | |
11 | |
9 | |
9 | |
7 | |
5 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.