FreeTDS Development Group

[Michael Peppler <mpeppler AT peppler.org>]

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