September 1, 2016 at 7:28 am
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.
September 1, 2016 at 7:41 am
Can you provide an example of what you are getting as well as what you should be getting?
-- Itzik Ben-Gan 2001
September 1, 2016 at 8:41 am
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy