Continue a SQL Query after a Warning Message from Driver

Keywords: 	 SQL warning

---

Question:

Is there an ODBC function that I can use to tell the ODBC query to continue on, even if I receive WARNING messages from the driver?

I was looking at SQL_TXN_ISOLATION under qSetConnOpt, but it's not clear to me what to use.

Answer:

Try this:

  qSetConnOpt(hdbc, 111, DllHWnd(""), @FALSE)

This sets the SQL_QUIET_MODE option, by specifying the WinBatch window handle as the owner of any dialog boxes that the SQL driver might need to display. It may be defaulting to a NULL handle, in which case no dialogs would be displayed. I don't know if this will work, but it's worth a try.

---

Article ID:   W12532

Filename:   Continue a SQL Query after a Warning Message from Driver.txt