i have a problem with my vb program. I encountered a run time error: 'ODBC SQL driver timeout expired.'
I executed an sql statement:
" SELECT distinct(ref), mkg, vessel_name From posummview WHERE podate > DATEADD(day,-DAY(GETDATE()),DATEADD(month,-2,getdate())) and Not mkg is null AND mkg <> '' and officer ='" & frmLogin.logName & "'"
the program must show the Purchase Order listing in a grid.
i cant find way of getting rid of this. this error pops up and the grid doesnt show up.
i hope you could email me if you have any idea.
September 17, 2004 3:26 AM
September 17, 2004 8:42 AM