Test data connection with scripterror and variable
Hello everybody, I want to test my sgbd connection before to launch the download of data. So,i simule a try catch with qliview with ErrorMode=0;
set ErrorMode=0; OLEDB CONNECT TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=patient;Data Source=TDV03DVGHT211;Extended Properties=""] (XPassword is TOTOZKeGYYIGTBNKDbcGYJOATYIGTBNKDbcGYJOATYIGTBNKDbcGYJOADeB); ErrorLog: LOAD '$(ScriptErrorCount)' as vScriptErrorCount, '$(#ScriptError)' as vScriptErrorNo, '$(ScriptError)' as vScriptError, '$(ScriptErrorDetails)' as vScriptErrorDetails AutoGenerate(1);
This script it's OK but when i varies my connexion string, it'KO...
set ErrorMode=0; $(vCONNEXION); ErrorLog: LOAD '$(ScriptErrorCount)' as vScriptErrorCount, '$(#ScriptError)' as vScriptErrorNo, '$(ScriptError)' as vScriptError, '$(ScriptErrorDetails)' as vScriptErrorDetails AutoGenerate(1);
The variable ScriptError is empty 😞 Have you an idea why ? how can i get around this ? do you have another solution ? Thanks a lot. Lionel