adwat
asked on
Crystal Report and Oracle Database
Sir,
I developed many crystal report using ODBC connetion and MSSQL database. I want to use same report with Oracle Database. Please Advise me What are the changes should I do in report so that these report work with Oracle database
Thanks
I developed many crystal report using ODBC connetion and MSSQL database. I want to use same report with Oracle Database. Please Advise me What are the changes should I do in report so that these report work with Oracle database
Thanks
Oracle connections to Crystal can be troublesome.
What version of Crystal?
What version of Oracle?
mlmcc
What version of Crystal?
What version of Oracle?
mlmcc
Crystal9 supported platforms
http://support.businessobjects.com/communityCS/TechnicalPapers/cr9_platforms.pdf
Crystal10 supported platforms
http://support.businessobjects.com/communityCS/TechnicalPapers/cr10_supported_platforms.pdf
mlmcc
http://support.businessobjects.com/communityCS/TechnicalPapers/cr9_platforms.pdf
Crystal10 supported platforms
http://support.businessobjects.com/communityCS/TechnicalPapers/cr10_supported_platforms.pdf
mlmcc
ASKER
Iam Using VB.NET and ODBC(RDO) connection with MSSQL and Crystal Report 10 Developer Edition. These reports developed with MSSQL and now I want connect with Oracle 9i. In oracel and MSSQL database name is same and all views and procedure are same. Without changing anything (wihout using set location option in Crystal Report) in report, with my ODBC(RDO), is it possible to connect crystal report with oracle. Or I don't know, I made any mistake in connection and preparing report. Sir this is the scenerio. Please Help
I don't know. I don't use ODBC connections and have only MSSQL to work with.
mlmcc
mlmcc
Hi,
Thanks for providing the info about the programming language!
Can you provide a peace of code showing how you used to connect your specific report to MSSQL and how you're attempting to do that with ORACLE now?
Without seeing your code this will remain theory <- and in theory most everything seems possible ;-)
Best regards,
Raisor
Thanks for providing the info about the programming language!
Can you provide a peace of code showing how you used to connect your specific report to MSSQL and how you're attempting to do that with ORACLE now?
Without seeing your code this will remain theory <- and in theory most everything seems possible ;-)
Best regards,
Raisor
ASKER
Sir,
To Load report, I am not using any special code. I created DSN through ODBC and this DSN Connecting to MSSQL database. In form I am using report viewer and in its reportsource property assined rpt file name. And another problem is, it is asking Password every time. I want to avoid this also. Is it possible ??. Waiting for your reply. Thanks ....
To Load report, I am not using any special code. I created DSN through ODBC and this DSN Connecting to MSSQL database. In form I am using report viewer and in its reportsource property assined rpt file name. And another problem is, it is asking Password every time. I want to avoid this also. Is it possible ??. Waiting for your reply. Thanks ....
ASKER
Sir,
To Load report, I am not using any special code. I created DSN through ODBC and this DSN Connecting to MSSQL database. In form I am using report viewer and in its reportsource property assined rpt file name. After creating new connection with Oracle database, I opened the report and change the location of table and views in report through the setlocation property of report . Now report is asking Password every time. I want to avoid this also. Is it possible ??. Waiting for your reply. Thanks ....
To Load report, I am not using any special code. I created DSN through ODBC and this DSN Connecting to MSSQL database. In form I am using report viewer and in its reportsource property assined rpt file name. After creating new connection with Oracle database, I opened the report and change the location of table and views in report through the setlocation property of report . Now report is asking Password every time. I want to avoid this also. Is it possible ??. Waiting for your reply. Thanks ....
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi,
Regarding the additional information by adwat at: {https://www.experts-exchange.com/questions/21342682/Crystal-Report-and-Oracle-Database.html#13553966} I think that {https://www.experts-exchange.com/questions/21342682/Crystal-Report-and-Oracle-Database.html#13554088} was the correct answer ...
... so, I'd suggest "forced accepted" ... Accept Raisor{https://www.experts-exchange.com/questions/21342682/Crystal-Report-and-Oracle-Database.html#13554088}
Best regards,
Raisor
Regarding the additional information by adwat at: {https://www.experts-exchange.com/questions/21342682/Crystal-Report-and-Oracle-Database.html#13553966} I think that {https://www.experts-exchange.com/questions/21342682/Crystal-Report-and-Oracle-Database.html#13554088} was the correct answer ...
... so, I'd suggest "forced accepted" ... Accept Raisor{https://www.experts-exchange.com/questions/21342682/Crystal-Report-and-Oracle-Database.html#13554088}
Best regards,
Raisor
Are you using an ODBC connetion to your Oracle Database?
If yes, there'll be no changes at all ... if you're using the .NET Framework you'll need an Oracle Adapter to connect streight ... but even then, you'll use a DataSet or DataReader Object ... no problem for Crystal ...
If you'll be getting into any trouble ... you might take notice that you'll always find a way to connect directly to your database ... (at least using .NET) ...
By the way ... what programming language are you using?
Best regards,
Raisor