Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2003
    Posts
    54

    linked server question

    Hi,
    I have a linked server connection from SQL SERVER 2000 to Sybase 11.9.2 and can see all the tables and views in sybase database. But, when I try to access a table from MSSQL SQL query analyser it is not able to access one single table and gives the following error....
    I am a newbie in SQL2000. Please help.


    Server: Msg 7356, Level 16, State 1, Line 1
    OLE DB provider 'MSDASQL' supplied inconsistent metadata for a column. Metadata information was changed at execution time.

    Regards

    Subhas

  2. #2
    Join Date
    May 2003
    Location
    UK
    Posts
    220
    Howdy

    Please explain the configuration you are using :


    How is the linked server configured? ( e.g. security, collation, account impersonation, provider etc )

    Post back if probs

    Cheers

    SG

  3. #3
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,398
    http://support.microsoft.com/default...fwct082702.asp

    Read this ... might be useful ... search for sybase on this page

  4. #4
    Join Date
    Oct 2003
    Location
    Suzhou, China
    Posts
    4

    Re: linked server question

    Try to select data use:
    OPENQUERY ( linked_server , 'query' )
    instead of use:
    select * from linked_server.database.user.table

  5. #5
    Join Date
    Apr 2003
    Posts
    54
    Originally posted by sqlguy7777
    Howdy

    Please explain the configuration you are using :


    How is the linked server configured? ( e.g. security, collation, account impersonation, provider etc )

    Post back if probs

    Cheers

    SG
    I got the answer.SQL Server does not like Sybase tinyint datatype.

Posting Permissions

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