Server identifier

mariela_montero_at_ncsu.edu
Date: 09/10/04


Date: Fri, 10 Sep 2004 07:38:23 -0700


I am working with sql server trying to conect to a sybase
server. Trying to use the following statement:

exec open_acs_dds...rp_sqlredirect hrl_extract,"select *
from hrl_fall_99_id_view where ID>'000000100' and
((BldgName>'A' and BldgRegion <>'V') or HousingStatus
like 'C%') order by
ID",acs_dds,nteldsb,nteldsb,NTFLOW,acs_dds,acs_dds,housing_
vue2

I am getting this error:
Server: Msg 103, Level 15, State 7, Line 1
The identifier that starts with 'select * from
hrl_fall_99_id_view where ID>'000000100' and
((BldgName>'A' and BldgRegion <>'V') or HousingStatus
like 'C%') orde' is too long. Maximum length is 128.

Thanks

Mariela Montero