Skip to Content.
Sympa Menu

freetds - Re: Sybase error: Identifier too long.....Any help appreciated

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Michael Peppler <mpeppler AT peppler.org>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Sybase error: Identifier too long.....Any help appreciated
  • Date: Thu, 17 Jan 2002 09:01:12 -0800


Kevin Sayre writes:
>
> The problem I'm having is I get an Identifier too long error (shown below)
> when I attempt to run the query. I'm connecting to an Oracle db by using
> our MSSQL Server with a linked server setup. I'm able to get data if I
> simply select one field, so I know it's not a connection problem. Is
> there a max length setting somewhere that I can raise? Sort of tried
> everything I can think of so far. Thanks for any help.
>
> Warning: Sybase error: The identifier that starts with 'SELECT * FROM
> KARCHER.ODBC_RESIDENTIAL_VW WHERE ADDR_CITY_NAME LIKE '%Akron%' AND
> LIST_PRICE > 100000 AND LIST_PRICE
> < 150000 AN' is too long. Maximum length is 128. (severity 15)

I don't know MS-SQL, but that looks like an error in MS-SQL, or in the
software that handles the remote queries between MS-SQL and Oracle.

Michael
--
Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
mpeppler AT peppler.org - mpeppler AT mbay.net
International Sybase User Group - http://www.isug.com




Archive powered by MHonArc 2.6.24.

Top of Page