chinoy

Hi, I personally have not used stored procedures, but I don't see why it would not work. I would think that any odbc driver that supports stored procedures should work with the sql plugin. In my experience I have noticed that quite often I miss obvious things that are revealed upon closer examination. Some of my future projects may require me to use stored procedures, so if I have success, I'll let you know.

If what you are already doing does not work... try creating another OGM (copy of the first one.. ask for the variables again, which will overwrite the previous ones with the same name. So basically instead of repeating the OGM you would "call" the copy See if this helps

I believe you cannot as the web pages are created on the fly. I suggest that you create a separate web page, and call the IVR page within a (ugh) frame or iframe.

On the main OGM properties, experiment with different times in the wait section. Also, make sure that your message os long enough... It may be as simple as "Please hold while we lookup that information...." Hope this helps

This seems to be feasible.. A few questions : "Machine then takes address details for postage and stores in database" How does the customer input the address?? using the telephone key pad?? Also, processing the payment through the bank may require coding specific to the bank. You'll also need a telephony card ( http://www.nch.com.au/ivm/modems.html ) The telephony cards come in various "sizes" ie # of ports. That will depend on how many lines you have coming in and what the call volume is expected to be.

I can probably help you. If you're expecting the reply to be "E_cities" your ogm has to be named the same. Next you'll need to specify in the GO TO OGM box (on the main properties screen of the ogm). Typical settings: wait: in seconds (this will depend on how long your query takes... you'll need to adjust it up if you get a "time out" or query did not respond by the time OGM finished playing" Repeat : whatever you need Then: GO TO OGM (in the details : %Env_ogm% I think when you are using the select statement " select nv_ogm from accounts where nv_pin= '123456'". If you are expecting the result to be env_ogm, then the above is correct. Let me know if this helps. If you need more help, post your actual sql query or upload your IVR file and I'll be glad to have a look.

As we all know the sql plugin does have limitations, It will not accept long sql statements, therefore you have to break the statement into several, while passing the previously received variable to the next and so on. Quite frankly, I think the limitation is in the IVM Plugin entry screen rather than the sqllink plugin itself. You get the same limitation no matter what plugin u use. It is extremely frustrating, because I have an sql statement that is 4 lines, but since I can use one single long query, I have to break it down into 7 separate queries, and that means I have to run the plugin in the same OGG 7 times. Secondly, The program allows you to run many plugins within the same OGM (or the same plugin several times in my my case), however, the program will not allow me to modify the order of the plugins or insert in between 2 OGMs. Example, I have 7 plugins I run (same plugin, 7 times). I wanted to add another plugin between the 3rd and the 4th one, however, I cannot insert, so I had to delete the 4th, through the 7th plugin, insert a new entry and then recreate the ones I deleted. In summary: 1. Modify the plugin entry screen to accept longer lines (in case of sql statements, there is no real limit on statements, I have seen some that are 2 pages long) 2. Allow us to modify the order of the plugins within a single OGM (particularly since it is allowing to add multiple plugins in the first place. Asides from this, I think the program is just GREAT and very flexible. I do hope the development team adds these features in the next revision. Regards, Ray

Not sure if you got your answer... To get this plugin to work, you'll have to specify the name and path of the sqllink.exe in the RUN EXE section In the With Arguments Section: 1. enter the dsn name (in your case AC) 2. Type the sql query It works for me, though I don't do any inserts