Need Assistance ASAP

[nosajld]

Greetings -

I have a big problem here and hope someone can assist or point in the right direction.

We have a ShoreTel server (phone system) that stores data in a single mysql db file. When I access the server and run any rpt from the webbased director the data is correct. When I open up the same report from my workstation in CR XI I only receive partial data. No error, no flags.

Example:

Extension 6300 will show 455 calls during the month of Nov through the report run on the server. When I run on my workstation with the exact same parameters I only get 11 calls for the same parameters.

The connection string is as follows:
DRIVER={MySQL ODBC 5.1 Driver};SERVER=10.50.2.2;PORT=4309;DATABASE=shorewarecdr;USER=st_cdrreport;password=passwordcdrreport;charset=utf8

the only difference I can find between the two setups are I'm using the MYSQL 5.1 drvr and the server has a ShoreTel mysql driver and the "Server" in the connection string is listed rather than localhost.

The reports call a sql file located on the server which I have not done anything with nor have I moved to my workstation.

Sorry this is long I wanted to be sure to provide as much info as possible. Any assistance lended would be greatly appreciated.

Thank you

 

[Turkbear]

Hi,
2 things:

Did you use the same username/password as in the server's setup?

Have you tried changing your connection to use the ShoreTel MySql driver? - there can be some differences between drivers but usually not that type of problem.



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[nosajld]

first Question: I assume you mean the connection string?

Second Question: spoke with Shoretel and they said their driver is basically a repackaged 5.1 and if it were to cause issues it wouldn't be like this.

Thanks for your quick response!

 

[nosajld]

Alright....feel like an idiot here...and there...and everywehre today.

You would think after 10 years in the miltary I would consider this...

I have the time hard coded as 11:59:59 (noon) instead of 23:59:59 (midnight)...so only half the day's data is pulled...what a difference that makes

Thank you again TB - you've been a big help! It has been too long since I've touched CR - I need a book reference ASAP.

 

[Turkbear]

HI,
There is an online site from IBM that contains a CR section which is very similar to CR's own online help..I find it useful when looking up things since I do not have CR installed:

http://publib.boulder.ibm.com/infoc...ation.eclipse.designer.doc/html/topic629.html

also this book:

http://books.google.com/books?id=is...resnum=14&ved=0CF4Q6AEwDQ#v=onepage&q&f=false

has much detailed info about the product ( at least XI)

and Amazon has many:

http://www.amazon.com/s/?ie=UTF8&ke...=aps&hvadid=4385782395&ref=pd_sl_3oxcszylbt_e

To Paraphrase:"The Help you get is proportional to the Help you give.."