ok...well.....I built an IVR system that uses ODBC to connect to the
RBase database using the Oterro 3.5 driver. The IVR works great reading
and writing to the Rbase database through Oterro ODBC driver and
executes the stored procedure from a trigger just dandy. Its the stored
procedure executed by Oterro that needs to launch a DOS command file
that runs cURL.exe.
I don't know what language the IVR system was written in. My IVR scripts
are called Callmaster Basic. Its an interpreted scripting language for
that IVR system (kinda like rbase command files are interpreted by
Rbase). So its not compiled Oterro Dll's. We are using the Oterro ODBC
driver to get to the database.
I have even tried to use the Rbase 7.6 ODBC driver for the IVR and that
works fine too. Its the launch command in the stored procedure that
won't run. Maybe its my syntax for the launch command in the stored
procedure.
SET VAR vLaunch = 'LAUNCH request.cmd'
&vLaunch
Thom
MikeB wrote:
Also Thom, you haven't said what programming language you are using
for the front end to Oterro, or is the Oterro instance on the server
being accessed by your RBase sessions on the Lan and the Wan?
----- Original Message ----- From: "Thomas Cimicato"
<[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Friday, March 19, 2010 12:20 PM
Subject: [RBASE-L] - Oterro Launching cmd.com
Can Oterro 3.5 running a stored procedure "launch" a command line
process .bat or .cmd file? I can get it to work in my local RBase 7.6
environment but Oterro does not seem to execute the launch. Oterro
executes the stored procedure/trigger nicely it but it doesn't
execute the "launch test.bat" DOS command file that I need the
stored procedure to run.
Will Oterro execute a UDF if I convert the batch file to a UDF of
some sort?
Any comments are welcome.
Thanx
Thom
