What is the max length of LongVarChar in ODBC

raj158347 · Post by **raj158347** » Tue Jul 01, 2008 7:25 am

Hi,
We want to retrieve data from SQl server which has data type as TEXT in SQL server.
The DataType specified in the ODBC stage is LongVarChar with length of
2147483647
When the data lengh is exceed 192203 we are not able to view the data through ODBC satge and when ever we try to open the ODBC stage it is hang for some time and connection was terminated
Even the job also got abort.

Please help me to resolve the issue ?
Let me know any length limitation for LongVarChar

thanks in advance for your help

Regards
Raj

chulett · Post by **chulett** » Tue Jul 01, 2008 7:51 am

Check the documentation for the stage, I'll wager you'll find a TEXT field is not supported.