AnsweredAssumed Answered

'PIOLEDB' failed with no error message available, result code: DB_E_PARAMNOTOPTIONAL(0x80040E10).

Question asked by gaurav1107 Champion on Jun 15, 2017
Latest reply on Jun 22, 2017 by gaurav1107

Hello All,

I am trying to run a SQL query using PI OLEDB Provider. When I am specifying a hard-coded parameter for extended descriptor, it is giving me output but when I am using a RIGHT function, the query is giving the below error.

 

'PIOLEDB' failed with no error message available, result code: DB_E_PARAMNOTOPTIONAL(0x80040E10).

 

 

Query With Error -

 

 

Any suggestions for work around would be highly appreciated.

 

Regards,

Gaurav Agrawal

Outcomes