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

Question

Question

Kyle Johnson · Dec 29, 2017

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?

Discussion (3)1

Log in or sign up to continue

Robert Cemper · Dec 29, 2017

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) }

1 0

score 0 · Answer 1 · 2018-01-25T15:32:26-05:00

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.

score 0 · Answer 2 · 2024-08-02T18:55:05-04:00

Jeff Cleath · Aug 2

I have the same problems with a lot of different queries for different tables. Did you ever find a solutions?

0 0