private static ConnectionInfo GetCrystalConnectionInfo()
        {
            ConnectionInfo crConnectionInfo = new ConnectionInfo();
            DbConnectionAttributes dbAttributes = new DbConnectionAttributes();

            switch (CommonConfig.TipoDatabase)
            {
                case TipoDB.MsAccess:
                    //setup the attributes for the connection
                    dbAttributes.Collection.Set("Data Source", Path.Combine(CommonConfig.AccessDatabasePath, "Dati.mdb"));
                    dbAttributes.Collection.Set("Database Type", "Access");
                    //dbAttributes.Collection.Set("Locale Identifier", "1040");//l'ho aggiunta io - in origine 1033 (USA)
                    dbAttributes.Collection.Set("OLE DB Services", "-1");//l'ho agginta io in origine "-6", ma "-1" corrisponde a "tutti i servizi"
                    dbAttributes.Collection.Set("Provider", CommonConfig.AccessProviderName);//l'ho aggiunta io
                    //dbAttributes.Collection.Set("Jet Database Password", "password");// aggiungere questo se DB protetto da password
                    //setup the connection
                    crConnectionInfo.LogonProperties.Clear();
                    crConnectionInfo.Attributes.Collection.Clear();
                    crConnectionInfo.DatabaseName = "";
                    crConnectionInfo.ServerName = Path.Combine(CommonConfig.AccessDatabasePath, "Dati.mdb");
                    crConnectionInfo.UserID = "";
                    crConnectionInfo.Password = "";
                    crConnectionInfo.Attributes.Collection.Set("Database DLL", "crdb_ado.dll");
                    crConnectionInfo.Attributes.Collection.Set("QE_DatabaseName", Path.Combine(CommonConfig.AccessDatabasePath, "Dati.mdb"));
                    //crConnectionInfo.Attributes.Collection.Set("QE_DatabaseType", "Access/Excel (DAO)");
                    crConnectionInfo.Attributes.Collection.Set("QE_DatabaseType", "OLE DB (ADO)");
                    crConnectionInfo.Attributes.Collection.Set("QE_LogonProperties", dbAttributes);
                    crConnectionInfo.Attributes.Collection.Set("QE_ServerDescription", Path.Combine(CommonConfig.AccessDatabasePath, "Dati.mdb"));
                    crConnectionInfo.Attributes.Collection.Set("QE_SQLDB", true);
                    crConnectionInfo.Attributes.Collection.Set("SSO Enabled", false);
                    crConnectionInfo.LogonProperties = dbAttributes.Collection;
                    break;

                case TipoDB.SqlServer:
                    //setup the attributes for the connection
                    dbAttributes.Collection.Set("Auto Translate", "-1");
                    dbAttributes.Collection.Set("Connect Timeout", "15");
                    dbAttributes.Collection.Set("Data Source", CommonConfig.SQLServerDatabaseServerName);
                    dbAttributes.Collection.Set("General Timeout", "0");
                    dbAttributes.Collection.Set("Initial Catalog", CommonConfig.SQLServerDatabaseDatabaseName);
                    dbAttributes.Collection.Set("Integrated Security", true);
                    dbAttributes.Collection.Set("Locale Identifier", "1040");//  in origine 1033 (USA)
                    dbAttributes.Collection.Set("OLE DB Services", "-1");// in origine "-5"
                    dbAttributes.Collection.Set("Provider", "SQLOLEDB");
                    dbAttributes.Collection.Set("Tag with column collation when possible", "0");//
                    dbAttributes.Collection.Set("Use DSN Default Properties", false);
                    dbAttributes.Collection.Set("Use Encryption for Data", "0");//

                    //setup the connection
                    crConnectionInfo.LogonProperties.Clear();
                    crConnectionInfo.Attributes.Collection.Clear();
                    crConnectionInfo.DatabaseName = CommonConfig.SQLServerDatabaseDatabaseName;
                    crConnectionInfo.ServerName = CommonConfig.SQLServerDatabaseServerName;
                    crConnectionInfo.UserID = "";
                    crConnectionInfo.Password = "";
                    crConnectionInfo.IntegratedSecurity = true;   //AGGIUNTO DA ME
                    crConnectionInfo.Attributes.Collection.Set("Database DLL", "crdb_ado.dll");
                    crConnectionInfo.Attributes.Collection.Set("QE_DatabaseName", CommonConfig.SQLServerDatabaseDatabaseName);
                    crConnectionInfo.Attributes.Collection.Set("QE_DatabaseType", "OLE DB (ADO)");
                    crConnectionInfo.Attributes.Collection.Set("QE_LogonProperties", dbAttributes);
                    crConnectionInfo.Attributes.Collection.Set("QE_ServerDescription", CommonConfig.SQLServerDatabaseServerName);
                    crConnectionInfo.Attributes.Collection.Set("QE_SQLDB", true);
                    crConnectionInfo.Attributes.Collection.Set("SSO Enabled", false);
                    crConnectionInfo.LogonProperties = dbAttributes.Collection;
                    break;
            }
            return crConnectionInfo;
        }