[sconan]

We’re thinking about using Crystal Reports for some of our reporting needs, so we downloaded an evaluation version to give it a whirl. I’ve run into a problem trying to set it up…

Scenario 1: Broken ODBC – Working Crystal Reports

When I install the eval version of Crystal Reports, it runs fine, but the NS ODBC connector breaks with:

“Error Connecting to Database: ERROR [IM003]

Specified driver could not be loaded due to system error 998 (NetSuiteODBCDriver).”

Scenario 2: Broken Crystal Reports – Working ODBC

If I boot into safe mode and re-install the latest version of OpenSSL and the ODBC Connector, it once again runs. Unfortunately, Crystal Reports breaks. It can no longer start the service

“Central Management Server”

These two things lead me to believe that I’m running into an OpenSSL version mismatch. Anyone have some ideas on how to fix it? We’re running this on a Windows Platform, using IIS 6 and .NET.
This is a cached copy. Click here to see the original post.

[jessie]

RE: New ODBC Connector and Crystal Reports XI R2

I have not used the NS ODBC connector but have a few battle scars from the combination of ODBC and Crysta. Not all ODBC is created equal and at time Crystal can be flaky.

Have you tried accessing the ODBC connector using another tool? Something like MS-Access using “Linked Tables” or MS-Excel using Data | Import External Data | New Database Query? Both Access and Excel are using the same Jet engine so if one works the other should as well.

Point being try to make sure the ODBC layer is functioning properly outside of Crystal.

[jimbayca]

RE: New ODBC Connector and Crystal Reports XI R2

i’ve used the new ODBC views with Crystal without any issues for a while. However if i’m outside the office and have a VPN connection open then i get the same error message you do

[Former UG member – changed by Mod 2784]

RE: New ODBC Connector and Crystal Reports XI R2

I use CR all of the time. I havent tried it today, but I did do our financial statements yesterday without an issue. I use CR version 11, with netsuite odbc. I also use Excel with the ODBC. There are times when the tables come up empty in Excel, but it is just a matter of opening and closing the tables by choosing them directly.

Try it in Excel. However, if you do not have the advanced reporting add on, it won’t work in either for you.

[BradB]

RE: New ODBC Connector and Crystal Reports XI R2

One of the Netsuite guys suggested DAFT to us. Open Source Client tool. Just for info – Access Linked tables caused us issues by truncating text, and truncating the decimal places off of % values.

[sconan]

RE: New ODBC Connector and Crystal Reports XI R2

Thanks for the replies guys. So far here’s what I’ve found out:

1) The ODBC connector works correctly if I use the newest version of OpenSSL 0.98e.

2) After I install Business Objects, which seems to use a different version of OpenSSL, the ODBC connector breaks.

3) If I reinstall the 0.98e version of OpenSSL, the NS ODBC tool works, but Business Objects fails to start the CMS service in the Services Control Panel.

I think I’ll be calling Netsuite later today to see if they have some suggestions.

Brad: What is DAFT and where might I find it?

[jswift]

RE: New ODBC Connector and Crystal Reports XI R2

We have Crystal Reports Developers Verison Eleven working and if I can help you, let me know. It took me awhile to get it to work. I also have it working as an excel query and in reporting services.

Thanks

[Author]

Posts