Oracle Database Discussions

Hi,

i am having some difficulty in getting authenticated for the crystal reports applications.

i am able to query data from my application from oracle database. i cant seem to be able to connect to the database tho thru crystal report

any ideas?

as soon as the report starts to display, it gives the following:

my code is as follows:

//// Change Credentials Here

        CrystalDecisions.CrystalReports.Engine.Database crDb;

        CrystalDecisions.CrystalReports.Engine.Tables crTables;

        CrystalDecisions.CrystalReports.Engine.Table crTable;

        TableLogOnInfo crTableLogOnInfo;

        ConnectionInfo crConnInfo;

        crDb = objRpt.Database;

        crTables = crDb.Tables;

        crConnInfo = new CrystalDecisions.Shared.ConnectionInfo();

        crConnInfo.ServerName = "ORCL";

        crConnInfo.DatabaseName = "192.1.50.X";

        crConnInfo.UserID = "XXXX";

        crConnInfo.Password = "XXXX";

        for (int i = 0; i \< crTables.Count; i++)

        {

                 crTable = crTables\[i\];

        crTableLogOnInfo = crTable.LogOnInfo;

        crTableLogOnInfo.ConnectionInfo = crConnInfo;

        crTable.ApplyLogOnInfo(crTableLogOnInfo);

        }