Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2009
    Posts
    12

    Unanswered: linked access server metadata info does not match error

    hello,


    i have an access database as a linked server inside sql server 2005.

    the query giving me an issue is the following:

    select * from Openquery (OEA, 'Select * from header')

    the error message is:

    OLE DB provider 'Microsoft.Jet.OLEDB.4.0' for linked server 'OEA' returned data that does not match expected data length for column '[Microsoft.Jet.OLEDB.4.0].City'. The (maximum) expected data length is 100, while the returned data length is 9.


    i dont know how i can fix this.. i've read that it has to do with the metadata info not being in sync...

    help would be awesome.



    as a workaround, instead of doing a select * on the table header, im doing a select on just the fields that i need ( which does not include the field city) but thats a problem waiting to happen if i leave it like it is

    thanks!!

  2. #2
    Join Date
    Sep 2009
    Posts
    12
    ttt anyone?

  3. #3
    Join Date
    Sep 2009
    Posts
    12
    ttt pretty please?

  4. #4
    Join Date
    Sep 2009
    Posts
    12
    anyone have any ideas?

  5. #5
    Join Date
    Feb 2005
    Posts
    10
    are you using a fixed length field in your SQL server?

    try setting the data type to be the same as the source column

  6. #6
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    (OEA, 'Select * from header')

    What about if you do

    select * from OEA.database.owner.header ? does it yield the same result ?

    what about

    select * from Openquery (OEA, 'Select * from database.owner.header') ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •