3146 - ODBC - call failed

[abpatind]

I am having trouble while running a query which has two linked tables from SQL Server database. This query was working fine and suddenly, it start giving following error.

"3146 - DBC - call failed"
[Microsoft][ODBC - SQL Server Driver] Timout expired(#0)

The query is;

INSERT INTO PSA_SalesInputTbl ( StoreKey, BusinessDay, ProdKey, ProdNum, ProdDesc, Multiplier, SalesQty, Qty, Category )
SELECT dbo_vistMDTRPRODUCT.STORE_KEY, dbo_vistMDTRPRODUCT.BUSINESS_DAY, dbo_vistMDTRPRODUCT.PRODUCT_KEY, dbo_vistMDTRPRODUCT.PRODUCT_NUM, dbo_vistMDTRPRODUCT.PRODUCT_DESC, dbo_vistMDTRPRODUCT.MULTIPLIER, dbo_vistMDTRPRODUCT.SALES_QUANTITY, ([Multiplier]*[Sales_Quantity]) AS Qty, IIf([Sub_Category_Id]="001","R","G") AS Category
FROM dbo_vistMDTRPRODUCT INNER JOIN dbo_vistMDCFPRODUCT ON (dbo_vistMDTRPRODUCT.PRODUCT_KEY = dbo_vistMDCFPRODUCT.PRODUCT_KEY) AND (dbo_vistMDTRPRODUCT.STORE_KEY = dbo_vistMDCFPRODUCT.STORE_KEY)
WHERE (((dbo_vistMDTRPRODUCT.STORE_KEY) Not Between 39 And 52) AND ((dbo_vistMDTRPRODUCT.BUSINESS_DAY)>=[Forms]![PSA_frmSalesPurRpt]![txtstartdt] And (dbo_vistMDTRPRODUCT.BUSINESS_DAY)<=[Forms]![PSA_frmSalesPurRpt]![txtenddt]) AND ((dbo_vistMDCFPRODUCT.CATEGORY_ID)="018") AND ((dbo_vistMDCFPRODUCT.SUB_CATEGORY_ID)="001" Or (dbo_vistMDCFPRODUCT.SUB_CATEGORY_ID)="002"));

Any help will be highly appriciated.
Thanks,

 

[GingerR]

In the query properties, try setting ODBC Timeout to 0 (so it won't time out). Hope that works.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html