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
