>Hi All,
>I am getting this error from my one server but the same thing is working fine in other server.
>
>Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
>> [Microsoft][ODBC SQL Server Driver][SQL Server]The identifier that starts
>> with '(Status LIKE 'ST005%') And (C.OrganizationType LIKE 'VP%') And (City
>> LIKE 'san francisco%') And (State LIKE 'ca%') And (Zip LIKE' is too long.
>> Maximum length is 128.
>
>
>I have NT 4.0
>
>thanks,
>...ashish
Don't know about the error but why aren't you using the native OLE DB provider for SQL Server ? It's faster because you don't have the additional ODBC layer.