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

  • Custom Crystal Reports Against ECC

    We recently upgraded to ECC 5.0. I contacted the TAC and they provided me with a read only username and password to access the ECC MySQL database. I can make a connection fine from my client machine. The problem is, I cannot pull any data??? I am working on my client machine because I have Crystal reports installed on my client machine. This is also where I setup my ODBC connection. Is there anything I need to do on the ECC server to allow external access to the database?

    Specifically, I am trying to create a report on release codes that i have attached.
    Attached Files
    Last edited by chadd39; 07-06-2009, 10:39 AM.

  • #2
    It should work.
    What are the settings?
    Give me an example query you are using and I can test against my own DB.
    I also have read-only access.


    • #3
      Are you trying to use the C2G reporting? If you are, ECC does not populate that database by default. You have to setup the connection for it under Connections->C2G if I remember correctly.