Remote server class definition setting

Issue

The sp_webservices add command may return the following error when generating proxy tables:

Warning: Row size (3347 bytes) could exceed row size limit, which is 1962 bytes.
Msg 208, Level 16, State 1:
Server 'JMALVARADO', Line 1:
tempdb..ws_4338e6e122cd4ef0a not found. Specify owner.objectname or uses to check whether the object exists (sp_help may produce lots of output).
No proxy tables were created for the WSDL URL:
[http://www.xignite.com/xquotes.asmx?WSDL]
(return status = 0)

This error occurs because the remote server representing the ASE Web Services Engine has been added using sp_addserver with a class other than “sds.” To verify that this is so, use sp_helpserver in isql:

sp_helpserver ws

Here, ws is the name of the ASE Web Services Engine. This is the default. The remote server class is returned in the indicated column of the result:

name network_name class ...
---- ------------ ----- ...
ws   ws           null  ...

User action

Change the class of the remote server to “sds” by using sp_dropserver and sp_addserver in isql:

sp_dropserver ws_name
...
sp_addserver ws_name, sds, ws_name

Here, ws_name is the name chosen for the ASE Web Services Engine.