FreeTDS Development Group

["Kevin Sayre" <kevin AT thekarchergroup.com>]

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