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.

asked 14 Aug '12, 08:49

lebpas's gravatar image

lebpas
1867815
accept rate: 0%

edited 14 Aug '12, 09:19

May you have run in a similar problem as in that FAQ?

Sorry, dumb suggestion, I thought you were using MS SQL to access SA procedures, but now I see you are trying the opposite...

(14 Aug '12, 09:27) Volker Barth

Is the SA database user listing the remote proc in Sybase Central the same user trying to execute the remote proc?

If not, are they mapped to the same extern login (aka MS logins)? Or may they be mapped to different MS logins having different permissions and/or MS default databases?

Yes, I know, no answers, just more questions:)

(14 Aug '12, 09:55) Volker Barth
Replies hidden

I use the same user, DBA, for the listing and to execute the remote proc.

(14 Aug '12, 10:30) lebpas

Could you please show the code for your external procedure and how you call it?

(14 Aug '12, 11:04) Volker Barth

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

permanent link

answered 14 Aug '12, 09:58

Volker%20Barth's gravatar image

Volker Barth
30.6k307456663
accept rate: 32%

1

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.

(14 Aug '12, 13:56) lebpas
Replies hidden

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

(14 Aug '12, 15:51) Volker Barth

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.

(14 Aug '12, 16:58) lebpas
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×28
×6

question asked: 14 Aug '12, 08:49

question was seen: 1,033 times

last updated: 14 Aug '12, 16:58