Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
blinton25
Yak Posting Veteran
90 Posts |
 Posted - 2004-03-19 : 19:11:38
|
| . Reply (E-mail) Forward (E-mail) Subject: ODBC call failed From: "blinton25" <blinton25@hotmail.com> Sent: 3/19/2004 9:20:34 AM Hello,I use Linked Tables to connect to my SQL Server database. I have a number of reports which worked fine when I was using test data (few thousand records).I just loaded in a million records and ran a report, and received the following error:ODBC call failedwhen running this query:TRANSFORM "~" & Count(IIf(DatePart('yyyy',[F_ARRV_DAT],1,0)=forms!DateRangePreviousCurrentYear!PrevYear,[Final_Clean Tourists Query].[TRAV-KEY])) & "~" & Count(IIf(DatePart('yyyy',[F_ARRV_DAT],1,0)=forms!DateRangePreviousCurrentYear!CurrYear,[Final_Clean Tourists Query].[TRAV-KEY])) AS Expr1SELECT [Final_Clean Tourists Query].REGIONS3, [Final_Clean Tourists Query].regionorderFROM [Final_Clean Tourists Query]WHERE [Final_Clean Tourists Query].REGIONS3<>''GROUP BY [Final_Clean Tourists Query].regionorder, [Final_Clean Tourists Query].REGIONS3PIVOT Format([F_ARRV_DAT],"mmmm") in ("January", "February", "March", "April","May","June","July","August","September","October","November","December");1. I am wondering if the query is not simply timing out. 2. Given that these queries were written for MS Access maybe I need to convert them into stored procedures to be called by the report.Any other suggestions? . |
|
|
|
|
|
|
|
ODBC Call Failed