You may have come across a situation where in INSERT/UPDATE/DELETE statements in your message flow returns an exception "[Microsoft][ODBC Driver Manager] Driver does not support this function".
Surprisingly mqsicvp would give a successful response and Test Connection from ODBC configuration panel would get connected successfully. However, only your message flows will fail to connect to Database. To fix this, follow the below steps
1. Go to Control Panel > Administrative Tools > Data Sources (ODBC)
2. Select System DSN tab. Select the datasource of your interest and Click on configure tab
3. Under Advanced tab, select the CheckBox against "EnableSQLDescribeParm"
Now run your message flows. You will find records getting successfully inserted in to the Database tables (provided all other configurations are correct :-) )
Surprisingly mqsicvp would give a successful response and Test Connection from ODBC configuration panel would get connected successfully. However, only your message flows will fail to connect to Database. To fix this, follow the below steps
1. Go to Control Panel > Administrative Tools > Data Sources (ODBC)
2. Select System DSN tab. Select the datasource of your interest and Click on configure tab
3. Under Advanced tab, select the CheckBox against "EnableSQLDescribeParm"
Now run your message flows. You will find records getting successfully inserted in to the Database tables (provided all other configurations are correct :-) )
perfect post. solved one of many setup frustrations!
ReplyDeleteThanks for the solutio
ReplyDeleteHello, my Friend! Thanks a lot!
ReplyDelete