Database Login window on Client Machine...

[Former Member]

hello:

I have application running SAP crystal report for vs 2010,

the reports shows fine on development machine (backend: sql server 2008 R2, OS: windows server 2003 R2)

however when i run same application on client server 64 bit machine (backend: sql server 2008 R2, OS windows enterprise server 2008), shows database login windows , i have installed 32 and 64 bit cr runtime also on client server, ran application on both 32 bit and 64 bit mode vis IIS7 and tried patched the server with CRforVS2010 runtime SP1 with no luck...

i am using OLD DB (ADO) while designing crystal reports on development machine....also verified sql native client for sql server 2008 exists on client server....

does CR for 2010 does not support window enterprise server 2008..??? OR i m making mistake somewhere...??.i am stuck in this for 5 days plz help......

Thanks...

here is my code...

  public ReportDocument LoadReport(string reportName)
        {
            rd = new ReportDocument();
            THFConnection.SQLConnection = Global.ConnString;
   
            rd.FileName = reportName; //Set Report Path

            ConnectionInfo connectionInfo = new ConnectionInfo();
            connectionInfo.ServerName = THFConnection.ConnInfo.ServerName;
            connectionInfo.IntegratedSecurity = THFConnection.ConnInfo.IntegratedSecurity; ;
            connectionInfo.DatabaseName = THFConnection.ConnInfo.DatabaseName;
            connectionInfo.UserID = THFConnection.ConnInfo.UserName;
            connectionInfo.Password = THFConnection.ConnInfo.Password;

            foreach (CrystalDecisions.CrystalReports.Engine.Table mytable in rd.Database.Tables)
            {
                TableLogOnInfo tableLogonInfo = mytable.LogOnInfo;
                tableLogonInfo.ConnectionInfo = connectionInfo;
                mytable.ApplyLogOnInfo(tableLogonInfo);
               
            }
            
            foreach (ParameterField pf in rd.ParameterFields)
            {
                if (pf.Name == "@SessionID")
                    rd.SetParameterValue("@SessionID", Global.SessionID);
            }
            return rd;
        } 

[former_member11696 · Accepted solution]

Hi Amit,

Moved your post to the .NET SDK forum.

It all is supported in Cr for VS 2010. Use the MS SQL Server Native 10 client whcih comes with SQL Server Client tools install or go to MS's site and download the client tools MSI for standalone installs.

MDAC version of Native Driver isn't supported for SQL Server 2008.

And yes use SP 1.

Thank you

Don

[Former Member · Accepted solution]

Thanks for the reply don....

the problem is still pending i tried re-installing MS SQL Server Native 10 msi on client machine...no luck...:(

usring sp1 runtime on client machine....

finally i decided to trace whats crystal reporting doing at client end...however i cant figure out what happening from this...plz take a look....

here r the links...

[http://dl.dropbox.com/u/28469634/mySlowReport_bkgrnd_3284_2011_05_14_11_44_52_139_trace.glf]

[http://dl.dropbox.com/u/28469634/mySlowReport_Diagnostics_3284_2011_05_14_11_44_49_325_trace.gl]f

[http://dl.dropbox.com/u/28469634/mySlowReport_functions_3284_2011_05_14_11_44_49_393_trace.glf]

[former_member11696 · Accepted solution]

Hi Amit,

You are still using the native client:

Provider=SQLNCLI;;Data Source=CYBASTRA\SQLEXPRESS2008

Provider=SQLNCLI10 is what it should be using.

You need to update the reports themselves either in the report designer or using the ReplaceConnection function.

Also, I'm not sure if SQL Express has a client or what MS supports so it may be an issue. MS forums may know if it's supported.

Thank you

Don

[Former Member · Accepted solution]

Hey Don,

i redesigned my report using SQLNCLI10 n that worked like a charm...:)

MS does have a native client 10 support so no issues there...

Thanks...

Amit