Data gets truncated and breaked

  • while fetching data through Linked server column data not display full qualified rows.

    Source server: Property vendor database, this database data can't visible normally and viewing thru ODBC query tool only.

    Destination server: SQL 2K8R2 installed and created linked server via ODBC name.

    SQL box, installed AIMAPI 3.4.3 odbc driver and created ODBC name from that ODBC name created linked server in SQL instance. Linked server test connection successfully and data also fetching but not fully qualified column data.

    Could you suggest me if any alternative ways?

    Thanks.

  • Can you provide an example of what you are getting as well as what you should be getting?

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

  • SQL Galaxy (9/1/2016)


    while fetching data through Linked server column data not display full qualified rows.

    Source server: Property vendor database, this database data can't visible normally and viewing thru ODBC query tool only.

    Destination server: SQL 2K8R2 installed and created linked server via ODBC name.

    SQL box, installed AIMAPI 3.4.3 odbc driver and created ODBC name from that ODBC name created linked server in SQL instance. Linked server test connection successfully and data also fetching but not fully qualified column data.

    Could you suggest me if any alternative ways?

    Thanks.

    I have to agree with Alan. There is much to go on here. Can you provide some additional details?

    We are volunteers and the more information we have the better chance we maybe able to assist. I personally don't know much about AIMAPI 3.4.3 so a little more information on this and the source server/database would be helpful.

Viewing 3 posts - 1 through 2 (of 2 total)

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