Click here to Skip to main content
15,896,912 members
Please Sign up or sign in to vote.
1.50/5 (2 votes)
See more:
i develope billing application in this application on my pc its work.
but on client pc open dialog box for database login.

and also ask for database login every time

i use code :

C#
System.Data.Common.DbConnectionStringBuilder builder = new System.Data.Common.DbConnectionStringBuilder();
                builder.ConnectionString = clsData_Helper.GetConnStr();
                

                crConnectionInfo = new ConnectionInfo();
                crConnectionInfo.ServerName = builder["Data Source"] as string;
                crConnectionInfo.DatabaseName = Billing_System.Classes.clsShareData.DataBaseName;
                Convert.ToString(builder["Password"]);               
                

                crConnectionInfo.IntegratedSecurity = true;
                crDatabase = CryRptDoc.Database;
                crTables = crDatabase.Tables;

                foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
                {
                    crTableLogonInfo = crTable.LogOnInfo;
                    crTableLogonInfo.ConnectionInfo = crConnectionInfo;
                    crTable.ApplyLogOnInfo(crTableLogonInfo);
                }             
                

                crystalReportViewer1.ReportSource = CryRptDoc;
Posted
Updated 28-Aug-12 0:52am
v6

1 solution

In Side your IIS changed the setting ...

Basic setting (in right site)--->Application Pool----->Select--->Classic .Net----->ok--->ok
 
Share this answer
 
Comments
[no name] 28-Aug-12 5:55am    
wht its affect??
Legor 28-Aug-12 6:06am    
From Oxford Dict:



"
Affect and effect are quite different in meaning, though frequently confused. Affect is primarily a verb meaning ‘make a difference to’, as in their gender need not affect their career

"
[no name] 28-Aug-12 6:51am    
wahh....realy u r very good english teacher.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900