[Migrated from old forumParticipant April 5, 2015 at 10:52 am Post count: 327]

#5690 |

Hi guys,

Can anyone tell me why ‘is-db-single-select’ sample from VDP is giving me 0 result?
It says zero. Result from ‘GetTotalAmount’ query is 45 and it should say 45 not 0.

Thanks

[Migrated from old forumParticipant April 5, 2015 at 10:53 am Post count: 327]

#5691 |

Bernard,
Which sample are you referring to? I checked the samples page but I’m not sure which one you are referring to so I can take a look.

Kevin

[Migrated from old forumParticipant April 5, 2015 at 10:53 am Post count: 327]

#5692 |

Hi Kevin,

is-db-single-select.vdp from samples folder, for Elastix.

[Migrated from old forumParticipant April 5, 2015 at 10:53 am Post count: 327]

#5693 |

Bernard,
Ok, I haven’t used that sample before. I’ll take a look at it.

Kevin

[Migrated from old forumParticipant April 5, 2015 at 10:53 am Post count: 327]

#5694 |

Bernard,

Try with fixed IP instead of localhost (default value when you install IS) for IS server location. I had the same issue on my Windows 7 laptop and had to change localhost with IP number to make it work. While on my WinXP desktop all worked fine like a magic, no need to change anything.
I am not sure if this is due to the OS because I had some other issues with my laptop but this helped. Try it…

DC

[Migrated from old forumParticipant April 5, 2015 at 10:54 am Post count: 327]

#5695 |

Bernard,
Also check that IS is running locally. Since I haven’t used hsql within vdp (I use mysql and mssql) I noticed an error when I tried the example and it turned out IS was not running on my machine locally. Go to \Visual Dialplan Professional\IS\bin\ and run ‘queryservice.bat’ and see if IS is installed as a service and running. If the returned info says false to installed and running then run ‘installservice.bat’ then ‘startservice.bat’. After it starts close the console window and run ‘queryservice.bat’ again and make sure installed and running say true. IS will then be installed as a service and start each time you start windows.

Kevin

[Migrated from old forumParticipant April 5, 2015 at 10:54 am Post count: 327]

#5696 |

Hi,

I managed, I just type my ip instead of localhost.