Finally Managed to Get My Reports to Run

After trying for two days, yesterday I finally managed to get our reports to run in Crystal Server 2013. We are using ODAC to connect to our Oracle 11g database, I tried installing the 32-bit ODAC but it doesn't work, thanks to a discussion on scn.sap.com, I uninstalled everything and started from scratch by installing the 64-bit ODAC then followed by the 32-bit, then I restarted the servers and configured both 32-bit and 64-bit System DSN to point to our Oracle database and it works!

By the way you can run this to open the 64-bit ODBC configuration:

c:\windows\system32\odbcad32.exe

And this for the 32-bit version:

c:\windows\syswow64\odbcad32.exe

Sigh, unfortunately even if I can open the reports from the server i.e. the CMC, our application still cannot access the reports, we are using Java so maybe we need to use newer SDK?

Comments

Post a Comment

Popular posts from this blog

Long-Term Visit Pass - Plus (LTVP-PLUS)

http://www.ica.gov.sg/news_details.aspx?nid=12665 Good news for those of us who cannot get PR for our beloved spouse, because the Singapore government has come up with a enhanced long-term visit pass called LTVP-PLUS or LTVP+. I'll sum up the key points in the FAQ provided by ICA so you don't have to go through one big page. Do let me know if I missed out anything or correction is required by dropping a comment. GENERAL LTVP+ will be in effect from 01 Apr 2012. LTVP+ holders will enjoy extended duration of residency, public healthcare subsidies and easier access to employment. No separate application required for LTVP+; an application for LTVP will automatically include your spouse for LTVP+, if eligible. LTVP applications submitted from 01 Feb 2012 will automatically be considered for LTVP+. The first approved LTVP+ will grant 3 years residency and subsequent renewal will be 5 years. Current holders of LTVP will be considered for LTVP+ on next renewal. If holde
Read more

How to Marry a Thai in Singapore

Image
You should refer to here -  https://www.rom.gov.sg/reg_info/rom_marriage.asp Please spend some time to go through and understand the information on that section (legal provision, other information, filing of notice, solemnization and etc), if your still not sure, feel free to drop a comment here or you can use their FAQ . The ROM website did a really good job of putting together the information that you need in a well-organized manner. I've done it once and I think the guide is very easy to follow. The only hiccup I've had with my marriage is during the  Appointment for verification & Statutory Declaration where both of us were required to read out a wall of text and my wife had difficulty getting past the first few lines and the counter guy got fed up and told my wife to stop. Definitely my oversight as I didn't arrange for an interpreter beforehand but luckily, there was a licensed interpreter at the scene and we managed to get her to do the interpretation fo
Read more

Commission Calculator for DBS Vickers SG Stocks

Made this little tool to help me calculate the costs of buying or selling a stock, just enter number of shares and price and it will show both buy and sell costs at the same time. Can even choose by cash upfront, online or phone and it will calculate using respective rates. Cash Upfront ONLINE By Phone Shares: Price: Value: Commission: Clearing Fee:
Read more