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: "Kevin Sayre" <kevin AT thekarchergroup.com>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Re: Sybase error: Identifier too long.....Any help appreciated
  • Date: Thu, 17 Jan 2002 12:18:29 -0500


> 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

Yeah, that's what I thought at first also, but I then placed the same SQL
statement into an ASP page running on IIS. That page returned the results
just fine when going through the same MSSQL server to the Oracle.




Archive powered by MHonArc 2.6.24.

Top of Page