Voicemail Pro & SQL Database

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
  • vcomsa
    Hot Shot
    • Jul 2013
    • 21
    #1

    Voicemail Pro & SQL Database

    Hy,

    I am working on a test environment right now.
    I have IPOffice 9.1 and Voicemail Pro 9.1 (running on Win 8.1)
    I have Installed SQL Server on another machine (Win 8.1)

    The problem is that Voicemail Pro find the data base, lets me connect to it ( Test Connection is Successfull ) but when I want to do a Database Execute it doesn't get any fields from my Table..





    The database:



    Any ideeas why this is happening ?

    Thank you!

    Vlad C.
    Tags: None
  • markgallagher
    Legend
    .
    • May 2010
    • 613
    #2
    From your screenshots the obvious would be that you haven't told it which fields to get. They have to be specified, it won't just get all by default.

    Comment

    • zakabog
      Genius
      • Aug 2014
      • 300
      #3
      Originally posted by markgallagher View Post
      From your screenshots the obvious would be that you haven't told it which fields to get. They have to be specified, it won't just get all by default.
      ^^^ Sounds about right, and you're probably better off cancelling the wizard and typing the query manually.

      Comment

      • vcomsa
        Hot Shot
        • Jul 2013
        • 21
        #4
        Hey guys,

        Sorry for the delayed response.. I was in vacation Now I am back and reviewing what I did ..
        From my pictures it is obvious that I can't tell the system what fields to choose since I don't have any options to choose from.
        I have also tried just typing in the query manually.. Same problem, It won't choose any and the action result of Database Execute is Failure... but the DB is being opened properly...

        I have tried the same on 2 differnet SQL DB installed on differnet machines..
        What am I missing ? :-?

        Comment

        • wkirk
          Brainiac
          .
          • May 2010
          • 61
          #5
          VMPRO IVR Requires Sever OS

          Voicemail Pro plus IVR and/or TTS

          Minimum hardware requirements: Basic Voicemail Pro RAM 512MB Hard disk free space 20GB Processor Pentium P4 2.8GHz Celeron Not tested. AMD Athlon XP 3000+, Athlon 64
          The following table provides a list of the operating systems that are supported for the server.
          Server OS Service 2008/2008 R2 Server 2012/2012 R2 Server
          If the database being queried is located on the Voicemail Pro server, the query speed of the database will be affected by the amount of memory available. You must take into account the memory requirements of the database being queried.
          Pre-requisites: For systems running Windows 2012, install .NET Framework 3.5 Features.

          Ports

          The Voicemail Pro service uses the following ports:
          Port Number Type Description 25 TCP Used to listen for SMTP connections. 37 UDP Used to receive time requests (RFC 868). 69 UDP Used to interchange the status, configuration, and program data. 80 TCP Used to service HTTP requests (Web Voicemail, mobility clients, one-X Portal for IP Office) for Voicemail Pro server running on Windows. 143 TCP Used to service IMAP4 requests. 514 UDP Used as the default port to write syslogs to a syslog server. 993 TCP Used to service IMAP4 requests over SSL. 50791 UDP Used to receive requests from IP Office PBX. TCP Used to receive requests from one-X Portal for IP Office and to receive connections from the Voicemail Pro Client application. 50792 TCP Used to communicate with the MAPI Proxy service. 8000 TCP Used to service HTTP requests (Web Voicemail, mobility clients, one-X Portal for IP Office) for Voicemail Pro server running on Linux.
          Note Voicemail can use additional ports for connection to services such as a third-party database or Microsoft Exchange.


          Kirk
          W.K. ‘Kirk’ Kirk | Sales Support Engineer lll | Worldwide Sales Engineering-Sales and Design Support Engineering – SMB Pre-Sales Support | Avaya | Voice: 1-888-297-4700 | [email protected]
          Use this link for the current IPO Matrix:
          https://sales.avaya.com/documents/1399549434213
          Click here for – IP Office Knowledge Base
          Please utilize our FAQ database tool before you engage the TechniCenter at:
          https://sales.avaya.com/en/general/search-the-technicenter-self-service-faq-tool
          To Contact the Technicenter call 1.888.297.4700 or 720.444.7700 or email [email protected] with the product in the subject line.

          Comment

          • havel3
            Guru
            • Nov 2012
            • 148
            #6
            If you have a succesfull database connection but you have no fields to select from then there is either something wrong with the connection string or with the database itself or with the ODBC driver.
            I assume you did create a ODBC connector first?

            Comment

            • vand250
              Member
              • Oct 2016
              • 5
              #7
              Has This problem already been resolved? We are experiencing the exact same problem.

              running VMPro 10.0

              Comment

              Previous template Next
              Loading