Connection to Oracle data source through Visual studio

[Former Member]

Hi All,

I am writing a C# .Net Windows application which can view and print Crystal Reports.

My report files are in server. I am loading reports using ServerFileReportManager.asmx web service.

For the reports using SQL Server views/tables I use following code to connect SQL database.

            TableLogOnInfos TableLogonInfos = new TableLogOnInfos();

            TableLogOnInfo TableLogonInfo;

            ConnectionInfo ConnectionInfo = new ConnectionInfo();

            SQLLoginInformation sqlLoginInformation = new SQLLoginInformation();

            sqlLoginInformation = GetRemotingObject().GetSQLLoginInformation();

            ConnectionInfo.ServerName = sqlLoginInformation.Server;

            ConnectionInfo.DatabaseName = sqlLoginInformation.Database;

            ConnectionInfo.UserID = sqlLoginInformation.UserId;

            ConnectionInfo.Password = sqlLoginInformation.Password;

            ConnectionInfo.AllowCustomConnection = true;

But I don't know how to connect to Oracle database. I have installed Oracle client 11g and created some Crystal reports using "Oracle Server" connection option as below;

I am using SAP Crystal reports for Visual studio 2010 version to create the reports.

Please provide me some sample coding for to connect to Oracle database.

Thanks in advance.

Kumara

[former_member188030 · Accepted solution]

Hi Kumara,

I used the the top right corner search box on this page and entered "crystal, oracle, .net, sdk, code" keywords.

Here is the very first result returned by the search.

http://search.sap.com/notes?id=0001905423&boj=/sap/bc/bsp/spn/scn_bosap/notes.do?access=69765F6D6F64...

Please search before posting.

- Bhushan

Senior Engineer

SAP Active Global Support

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

Getting started and moving ahead with Crystal Reports .NET applications.