Re: how to execute "set local mode to wait" with ODBC

Hi, Is there any particular need for the { } characters in the SQL? An alternative option would be to use the OpenLink driver, where you can have it execute any native SQL at connect time automatically - typically used for setting locking modes in Informix. OpenLink are available from http://www.openlinksw.co.uk/ for free evaluation download. Regards, ~Tim In article <6qd77q$q1b$1@nnrp1.dejanews.com>, glivengo@nwpacifica.net wrote: > Dear All Knowing Informix developers, I am trying to figure out how to > execute the "set lock mode to wait" for my ODBC connection to an informix DB. > note that I am running NT4.0 SP3 and using MFC 3.0's CDatabase and > CRecordset Classes. I tried placing the command in an SQLExecDirect call as > follows: RETCODE rc = SQLExecDirect(hStmt, (_TUCHAR*)"{set lock mode to > wait}", SQL_NTS); but I am getting a syntax error from the statement. > > I would appreciate it if someone would show me the actual commands that I > need to execute to set this informix variable. > > Thank you in advance for your help, > --Greg Livengood > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- > http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum > -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum