Newbie MS-SQL query timeout expired

Hints, tips and tricks for newbies

Moderators: Dorian (MJT support), JRL

Post Reply
skiko
Newbie
Posts: 8
Joined: Sun Dec 16, 2007 8:40 pm
Location: USA
Contact:

Newbie MS-SQL query timeout expired

Post by skiko » Tue Jan 04, 2011 3:53 pm

Newbie to SQL so any suggestions welcome
DBconnect seems to work fine, I get a resault = 1
DBquery works fine on some remote machines, but others I get
[MICROSOFT][ODBC - SQL Driver] Timeout expired
not sure where to look
THANKS!!

Code: Select all

LET>DD=TODAY

DBConnect>Driver={SQL Server};Server=SQLSERVER2005\MASTER;Database=movement;Uid=sa;Pwd=Password1;,dbH

Let>SQL=select [saleDate],[itemCode],[avgSalesPrice],[unitsSold],[dollarsSold],[soldPrice],[weight] from ItemMovement where saleDate ='%DD%' and unitsSold > '0' or saleDate ='%DD%' and weight > '0'

DBQuery>dbh,SQL,Field,numRecs,numFields

Post Reply
cron
Sign up to our newsletter for free automation tips, tricks & discounts