Welcome to

Welcome to!

This site was created as a place to share stories, tips, and troubleshooting help with ShoreTel/Mitel systems. ShoreTel/Mitel is obviously the MOST exciting VoiP platform on the market right now, and we realized there was no centralized place to discuss this platform, but now there is. Please feel free to join and share your experiences.

Please Note: This site IS NOT owned, funded, or managed by ShoreTel/Mitel, Inc. although you may find ShoreTel/Mitel employees sharing there experiences and expertise. If you would like more information on ShoreTel/Mitel systems, contact BTX at [email protected]

As always please support the advertisers that help support our site.

Thank You,
See more
See less
  • Filter
  • Time
  • Show
Clear All
new posts

  • ECC Sql Connect Error

    I'm writing a ECC script to connect to a ODBC DSN. In the SQL Connect script I selected three different music/ad scritps to determine where my connect script is failing. It keeps playing the error script. I "Tested" the ODBC setup and verified that the password was correct in the system tab of the ECC Director.

    1.Do you have to restart the ECC when you make changes to the interface section of the system settings?

    2. Is there a log file to see what's really going on?



  • #2
    Whenever you makes changes to the ODBC interfaces, you do need to restart the services. The drivers are only fired up when ECC is started.

    If you really want to see what's going on, you can start up the log viewer (d:\Shoretel\Contact Center Server\bin\bswlogmon.exe) and load up the database interfaces. The process in charge of that is EDBI. This will show you the exact SQL query that ECC is trying to run and the result it is getting back from the server.


    • #3
      ShoreTel ECC SQL

      I posted a 30 minute video tutorial on ShoreTel ECC SQL Scripting that covers this subject on the drvoip site. Sarsin is absolutely correct on the log, but I am confident you will find that you are having a data type mismatch. I aslo note that the Dial list does not like to have a LIMIT set (i.e. SELECt * FROM CALL_List Limit 0,30). ECC seems to want to read in 50 records at a time and if you set a lower limit it will not run. It will work with the scripting tool, but not in the dial list input statement.

      Last edited by Guest; 02-06-2009, 03:04 PM.


      • #4
        actually skip this and go direclty to the drvoip site. I have a bunch of ECC videos, MySQL etc.