ODBC Call Failed (#208)

[ertweety]

I have created a pass-through query for a very simple query and I'm getting the following error.

ODBC-Call Failed
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo_productMonthlyDetails'. (#208)

I'm not sure as to why. My query is ....

SELECT dbo_productMonthlyDetails.MbrNo, dbo_productMonthlyDetails.ProdCode, dbo_productMonthlyDetails.ProdBenefit, dbo_productMonthlyDetails.ProdSub, dbo_productMonthlyDetails.AverageBalance, dbo_productMonthlyDetails.DebitAverageBalance, dbo_productMonthlyDetails.CreditAverageBalance, dbo_productMonthlyDetails.RetailBranch, dbo_productMonthlyDetails.CBCBranch, dbo_productMonthlyDetails.MonthendDate INTO mt_step1_product_details_data
FROM dbo_productMonthlyDetails INNER JOIN Mth ON dbo_productMonthlyDetails.MonthendDate = Mth.Mth;

 

[Galaxiom]

Drop the "dbo_" from the table names because that is only on the linked table.
PassThrough talks directly to the server.