Hi Mike,
First of all I would like to thank you for your suggestions. I tried using the "Use Low Compatibility Mode" but sadly enough that doesn't fix my problem.
When I connect to my data source using the exact same ODBC-driver in Excel, I get the data that I'm looking for. Where do I go from here? Should I get all the data to Excel using the ODCB-driver and then connect to this Excel file using the Jet Data Manager or is there another option?
Best regards,
Jelle
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi,
In JetEnterprise I'm using an ODBC-driver to read data from an firebird database. When I use 'Preview Table' on a table from the data source all data is shown. But whenever I do the same action on the same table in my staging area, not the same data is shown. The colums with different data have the data type 'System.String' in my data source. Attached is an Excel file with two tabs to visualize my problem. What can I do to fix this problem?
Thanks in advance,
Jelle -
Jet Reports Historic Posts Hello Jelle,
The first thing I would suggest doing is checking the "Use Low Compatibility Mode" in the ODBC connection properties. See attachment.
If that doesn't work, can you connect to your firebird data source using the same ODBC driver but instead use Excel as the application. Does the data look the same as in the Jet Data Manager or does it look correct?
Thanks,
Mike D
Please sign in to leave a comment.