FreeTDS Development Group

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

Here's the SQL statement I am passing using PHP and FreeTDS on Linux:

$sql = "SELECT LIST_PRICE, ADDR_CITY_NAME, HIGH, BEDS_TOTAL,
FULL_BATHS_NUM, SQUARE_FOOTAGE, AGENT_NAME, AGENT_PHONE_NUM,
AGENT_AREA_CODE FROM OPENQUERY(CRISMLS, 'SELECT LIST_PRICE,
ADDR_CITY_NAME, HIGH, BEDS_TOTAL, FULL_BATHS_NUM, SQUARE_FOOTAGE,
AGENT_NAME, AGENT_PHONE_NUM, AGENT_AREA_CODE FROM
 KARCHER.ODBC_RESIDENTIAL_VW WHERE ADDR_CITY_NAME LIKE ''%Akron%'' AND
LIST_PRICE > 100000 AND LIST_PRICE < 150000 AND BEDS_TOTAL > 2 AND 
SQUARE_FOOTAGE > 2000 AND
FULL_BATHS_NUM > 1')";

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)

Kevin Sayre
kevin AT thekarchergroup.com