WinBatch Tech Support Home

Database Search

If you can't find the information using the categories below, post a question over in our WinBatch Tech Support Forum.

TechHome

ODBC
plus

Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.

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
File Created: 2017:07:28:13:58:31
Last Updated: 1999:04:15:16:47:52