A
Avadhoot Kulkarni
Guest
Which Progress DataDirect ODBC driver are you using? This information is not clear from the post. But most of our drivers do support MaxVarcharSize (MVS) Connection option. You can add this option in your ODBC DSN with MaxVarcharSize=8000. With this option driver would report the VARCHAR field size as 4000 in column Metadata as well as the result set metadata and SQL Server Linked Server will be able to work with the queries which include this field. Please note this might cause data truncation in cases were actual data is longer than 8000 characters. Also, though most of the ODBC driver has this option, it’s not there for all of them, so the answer is still subject to the driver you are using. Hope this helps. Regards, Avadhoot
Continue reading...
Continue reading...