RE: Server identifier

From: Nigel Rivett (sqlnr_at_hotmail.com)
Date: 09/12/04

  • Next message: shif: "passwrd" 
    Date: Sun, 12 Sep 2004 13:19:01 -0700

    Looks like a quoted identifier problem. You have quoted identifiers on so it
    thinks what is between "" is an identifier not a string.

    try

    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

    Note there are no double quotes in that statement. '' is two 's.

    "mariela_montero@ncsu.edu" wrote:

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

  • Next message: shif: "passwrd"