Error retrieving DATE(mm-dd-yyyy) from DB2 database

[sreeky]

I am getting this error while trying to get the date from DB2 database. I have the below code in VB 6. I don't have problems retrieving all the other data. This error occurs only if I try to get dates.

ERROR =>
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work done.

My SQL =>
mscSQL = "select D_SYS_CLSD from P.PQNCQIR where I_QLTYISS = " & otsIDOut

When I try to get the data this statement below gives that error
actualCloseDateOut = mscRs("D_SYS_CLSD&quot

Here actualCloseDateOut is declared as string.
otsIDOut is also declared as string.

I have no idea why this is happening. I would greatly appreciate if some one can give me the solution for this error.

Thanks,
sreeky