Could not figure out whats wrong with my sql statement - ado

While in the debug mode, take the value of strSTMT and execute it using something like SQL*Plus on the same machine as this.

 

Error somehow doesn't indicate any connection issues.

Also remote the single quotes around iStoreNum in the select statement.

I did whatever you guys have suggested me to do. but it did not work. for more detail, Application was written on .NET 2.0, I changed it to 4.5. Previously app was refrencing to oracle.dataaccess.client dll but since it isn't supported any more I installed OracleManagedAccess Client, is it because of this? I again encountered with similar situation with another program.

Please also put semicolon ; at the end of the statement.

 

For example:

" AND a.T_BATCH_ID = b.T_BATCH_ID );" 

I see that you have used iStoreNum variable at two places, but at one place you have added single quote before and after it, at another place you have not.

 

see this line

 There is a single quote ' before and after iStoreNum

Now see this line, there is no ' single quote before and after iStoreNum