cancel
Showing results for 
Search instead for 
Did you mean: 

MS SQL remote server procedure not found on Win 2K8 R2

Former Member
2,501

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.

Accepted Solutions (1)

Accepted Solutions (1)

VolkerBarth
Contributor

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...

Former Member

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.

VolkerBarth
Contributor
0 Kudos

Glad you got it working! BTW, what version of MS SQL Server are you using?

Former Member
0 Kudos

I believe it's 2005, but I'm not sure, that is/was part of the problem. It's from another software vendor of one of our client and they are not really helpful about their product.

Answers (0)