<p>Hi, all! I'm currently building a report to pull information from Canary Historian, and am running into some issues which I believe may be driver based. </p>
<p>A bit of background: I'm using BDPro v11.0.3 and the driver for the data source is <strong>sun.jdbc.odbc.JdbcOdbcDriver</strong>. I know from reading other posts in the forums that this is not the 'correct' driver to be using as it is only a stop-gap that Sun put out for temporary use. The report runs, but will only spit out sevens days' worth of data not matter what time span I use over seven.</p>
<p>I've run the query in QTODBC with no issues at all when searching 30 days of results. If I look at the driver info there, it says the name is CanaryODBCClientDriver from Simba Technologies, Inc., and the file name is CANARYODBCCLIENT.DLL. </p>
<p>I guess my question is: Is there a way for me to utilize that driver in BDPro to possibly alleviate the date range issues?</p>
<p> </p>
<p>Have a great day!</p>
<p> </p>
<p>Thanks,</p>
<p>Scott</p>
