Linked Server in SQL 2005 Query Problem???
Posted on 2010-11-17
I have the following query in M/S SQL Server 2005 Express which runs against a Linked MySQL Server. Nothing fancy just a select query that joins the product order details table with the work order table.
select* from openquery(linked_mysql, 'SELECT PRODUCT_ORDER_DETAILS.PRODUCTID, PRODUCT_ORDER_DETAILS.UNITPRICE, PRODUCT_ORDER_DETAILS.QUANTITY, WORK_ORDERS.* FROM WORK_ORDERS INNER JOIN PRODUCT_ORDER_DETAILS ON WORK_ORDERS.WO_ID = PRODUCT_ORDER_DETAILS.WO_ID')
I get the following error when it executes ...
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discard
Any help will be appreciated.