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??

If you want to access a source via Attunity Connect you should probably use the Attunity Connect OLEDB provider and not go via the OLEDB to ODBC bridge (which is what MSDASQL means).

Also if there is an underlying problem then the first place to look for it in is the Attunity Connect log file (usually found in the tmp directory under the product installation directory).

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.