[adminKeymaster January 20, 2017 at 5:52 am Post count: 7]

in reply to: Educational movies about Visual Dialplan for Asterisk #6586 |

Connecting to MSQQL Server using mixed mode authentication in Apstel IS

[adminKeymaster January 20, 2017 at 5:50 am Post count: 7]

in reply to: Educational movies about Visual Dialplan for Asterisk #6584 |

Connecting to MSSQL using Windows authentication in Apstel Integration Server

• This reply was modified 8 years, 5 months ago by  admin.

[adminKeymaster March 28, 2016 at 8:05 am Post count: 7]

in reply to: Importing vdp projet from desktop version to Elastix version. #6476 |

Hi Franck,

Visual Dialplan for Elastix keeps the VDP file at the following location:
/usr/local/apstel/vdp-pbx/wshome.default.vdp

If you want to move the file to be used in desktop version (Visual Dialplan Professional), just download the file to your desktop, rename it and open it in Visual Dialplan Professional.

If you want to move VDP file developed with desktop version, upload it to server, rename it and place it in the above folder.

Best regards,
Daniel

[adminKeymaster February 23, 2016 at 3:16 am Post count: 7]

in reply to: Persisting a DB connection #6471 |

Hello Pete,

IS does not support store procedures.
Try to reorganize it to work with regular SQLs.

Regarding the connection, check the Database properties (right click on the database name under the Database Resources, all at IS View within Visual Dialplan).
There are two tabs, Connection and Pooling with lots of parameters.
For parameters description, check the Integration Server documentation.

Hope this helps.

Best regards,
Daniel

[adminKeymaster November 9, 2015 at 2:17 pm Post count: 7]

in reply to: IS problem using queues #6466 |

Hello,

Please note that IS comes with 1 free DB module license.
For the second call (second simultaneous call) DB module will run out of licenses.
> 2015-11-03 14:24:03,147 [Asterisk-Java DaemonPool-1-thread-10] INFO apstel.is. – No available licenses for module: db

Regards,
Daniel

[adminKeymaster October 20, 2015 at 4:25 am Post count: 7]

in reply to: How to get a calling phone number from a database ? #6460 |

Glad to hear this!

• This reply was modified 9 years, 8 months ago by  admin.

[adminKeymaster October 19, 2015 at 12:05 pm Post count: 7]

in reply to: How to get a calling phone number from a database ? #6458 |

Hello Pierre,

Yes, it is typical scenario when Visual Dialplan and Integartion server are used.
Use the DbQuery component.
The easiest way is to start with bundled samples, single select DB sample.

These two articles will help you to get started:

http://www.apstel.com/visual-dialplan-tutorials/how-to-use-bundled-samples/
http://www.apstel.com/visual-dialplan-tutorials/database-connectivity/