Hi
I am using two linked server
Both have same tables by using sp_tables_ex 'linkedserver name' this I can see list of tables.One Emp table is available in that list but when I try
select * from Openquery(linkedserver,'select * from public.Emp')
then it show me error like
Error message:
-----------------------------------------------------------------------------------------
OLE DB provider "MSDASQL" for linked server "linkedserver" returned message "[Attunity][Attunity Connect Driver][01S01] [9035]Error in row.".
OLE DB provider "MSDASQL" for linked server "linkedserver" returned message "_Rate" AS c006, "T0000"."Assign_Misc2_Comm_Rate" AS c007, "T0000"."Assign_Misc3_Comm_Rate" AS c008, "T0000"."Assign_Misc4_Comm_Rate" AS c009, "T0000"."Assign_Misc5_Comm_Rate" AS c010, "T0000"."Assign_Misc6_Comm_Rate" AS c011, "T0000"."As
".
OLE DB provider "MSDASQL" for linked server "linkedserver" returned message "[Attunity][Attunity Connect Driver]Error processing definition for column "Address_1"
Cannot open translate file Emp
(OPEN)
[D000] Cannot open file
[A00D] Failed to open table linkedserver_ODBC:Emp
[A00A] Execute query failed, data source is 162_71_137_70, SQL text is SELECT "T0000"."Client_ID" AS c000, "T0000"."Address_1" AS c001, "T0000"."Address_2" AS c002, "T0000"."Adjustment_Amount" AS c003, "T0000"."Assign_Fees_Comm_Rate" AS c004, "T0000"."Assign_Interest_Comm_Rate" AS c005, "T0000"."Assign_Misc1_Comm".
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "MSDASQL" for linked server "linkedserver".
------------------------------------------------------------------------
Please help me??