Question
Kyle Johnson · Dec 29, 2017

OLE DB provider 'MSDASQL' for linked server returned data that does not match expected data length for column

I setup a linked server to a cache database to query the data and when I try an query the data I get 

 

OLE DB provider 'MSDASQL' for linked server 'xxx' returned data that does not match expected data length for column '[MSDASQL].CSFAELIGVENCITY'. The (maximum) expected data length is 20, while the returned data length is 23.

 

Should I be using a different driver when setting up the DSN?
 

0
0 3,443
Discussion (2)1
Log in or sign up to continue

Check MAXLEN for Property CSFAELIGVENCITY wherever that was defined.
 

As MAXLENis not checked for data output you may want to use a SQLcomputed property
that limits output to 20.

eg. {set {*}=$Extract(CSFAELIGVENCITY,1,20) }

I'm not understanding. I'm querying data through a linked server connection using SQL Server Management Studio. I doing a simple select * from table and getting that error. My Sr DBA can query the data fine through other tools and get no errors, so I'm thing it's SQL Server specific. H

Any help would be appreciated.