Post reply

'SQLOLEDB' supplied inconsistent metadata when using opendatasource

  • August 15, 2008 at 8:46 am

    #195905

    When I use opendatasource() and try to get data from the sysobjects table I get

    OLE DB provider 'SQLOLEDB' supplied inconsistent metadata for a column.

    I'm guessing that by connecting to the datasource I'm changing the table data or something???

    Thoughts appreciated.

    ST

  • August 18, 2008 at 7:07 am

    #859413

    Is there a way to get info from the remote server's sysobjects table using "opendatasource" ?

    Thanks

    ST

  • August 22, 2008 at 11:52 am

    #862060

    Possibly I'm not being clear. I have a system which needs to get information from another SQL database. It's an admin tool. I want to be able to pass the application connection information to the database it's inspecting.

    In my SQL database I have a query which says:

    select id, name from

    opendatasource('sqloledb', connString).myDB.dbo.sysobjects

    When I do this I get the mentioned error. IS this simply not allowed? Am I doing something wrong? Can anyone else make this connection? Can anyone else get the same error?

    Thanks

    ST

  • August 23, 2008 at 10:57 am

    #862251

    What is the sqlserver version of the datasource?

    I've gotten that error sometimes on sql server 7.

    (fix, http://www.sqlservercentral.com/articles/Bugs/changingcolumn/618/)

  • August 26, 2008 at 5:35 am

    #863024

    SQL 2000 for both the calling and called DB

    Thanks

    ST

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply