/// <summary> /// Converts the STRING database type to SAPbobsCOM.BoDataServerTypes /// </summary> /// <returns></returns> public SAPbobsCOM.BoDataServerTypes boDataServerType() { SAPbobsCOM.BoDataServerTypes st = SAPbobsCOM.BoDataServerTypes.dst_HANADB; if (this.DbServerType.Equals("MSSQL2017")) { st = SAPbobsCOM.BoDataServerTypes.dst_MSSQL2017; } else if (this.DbServerType.Equals("MSSQL2016")) { st = SAPbobsCOM.BoDataServerTypes.dst_MSSQL2016; } else if (this.DbServerType.Equals("MSSQL2014")) { st = SAPbobsCOM.BoDataServerTypes.dst_MSSQL2014; } else if (this.DbServerType.Equals("MSSQL2012")) { st = SAPbobsCOM.BoDataServerTypes.dst_MSSQL2012; } else if (this.DbServerType.Equals("MSSQL2008")) { st = SAPbobsCOM.BoDataServerTypes.dst_MSSQL2008; } else if (this.DbServerType.Equals("MSSQL2005")) { st = SAPbobsCOM.BoDataServerTypes.dst_MSSQL2005; } return(st); }
public static string consultaTablaConfiguracion(SAPbobsCOM.BoDataServerTypes bo_ServerTypes, string NAddon, string Version, bool Ordenamiento) { m_sSQL.Length = 0; switch (bo_ServerTypes) { case SAPbobsCOM.BoDataServerTypes.dst_HANADB: m_sSQL.AppendFormat("SELECT * FROM \"@{0}\"", NAddon.ToUpper()); if (NAddon != "" || Version != "") { m_sSQL.Append(" WHERE "); if (NAddon != "") { m_sSQL.AppendFormat("\"Name\" Like '{0}%'", NAddon); if (Version != "") { m_sSQL.AppendFormat(" AND \"Code\" = '{0}'", Version); } } else if (Version != "") { m_sSQL.AppendFormat("\"Code\" = '{0}'", Version); } } if (Ordenamiento) { m_sSQL.Append(" ORDER BY LENGTH(\"Code\") DESC, \"Code\" DESC"); } break; default: m_sSQL.AppendFormat("SELECT * FROM [@{0}]", NAddon.ToUpper()); if (NAddon != "" || Version != "") { m_sSQL.Append(" WHERE "); if (NAddon != "") { m_sSQL.AppendFormat("Name Like '{0}%'", NAddon); if (Version != "") { m_sSQL.AppendFormat(" AND Code = '{0}'", Version); } } else if (Version != "") { m_sSQL.AppendFormat("Code = '{0}'", Version); } } if (Ordenamiento) { m_sSQL.Append(" ORDER BY LEN(Code) DESC, Code DESC"); } break; } return(m_sSQL.ToString()); }
/// <summary> /// Connect only DI Api /// </summary> /// <param name="serverName">SQL Server Name</param> /// <param name="serverType">Server type</param> /// <param name="companyDb"></param> /// <param name="dbUsername"></param> /// <param name="dbPassword"></param> /// <param name="username">SBO Username</param> /// <param name="password">SBO Password</param> /// <param name="licenceServer">Licence Server</param> public static void DiConnect(string serverName, SAPbobsCOM.BoDataServerTypes serverType, string companyDb, string dbUsername = null, string dbPassword = null, string username = null, string password = null, string licenceServer = null) { _diCompany = new SAPbobsCOM.Company { Server = serverName, DbServerType = serverType, CompanyDB = companyDb }; if (licenceServer != null) { _diCompany.LicenseServer = licenceServer; } if (username == null) { _diCompany.UseTrusted = true; } else { _diCompany.UseTrusted = false; _diCompany.UserName = username; _diCompany.Password = password; _diCompany.DbUserName = dbUsername; _diCompany.DbPassword = dbPassword; } var connectResponse = _diCompany.Connect(); if (connectResponse != 0) { int errCode; string errMsg; _diCompany.GetLastError(out errCode, out errMsg); Logger.Debug($"Servername={serverName}, CompanyDb={companyDb}, ServerType={serverType}, " + $"DbUsername={dbUsername}, DbPassword={dbPassword}, " + $"SboUsername={username}, SboPassword={password}, " + $"LicenceServer={licenceServer}"); throw new Exception($"DI Connect Error: {errCode} {errMsg}"); } }
public static void ConnectViaDI(string server, string licSrv, SAPbobsCOM.BoDataServerTypes dbType, string companyDB, string dbUser, string dbPassword, string userName, string password, SAPbobsCOM.BoSuppLangs language, string addonID = "") { try { oCompany = new SAPbobsCOM.Company(); oCompany.Server = server; oCompany.LicenseServer = licSrv; oCompany.DbServerType = dbType; oCompany.DbUserName = dbUser; oCompany.DbPassword = dbPassword; oCompany.CompanyDB = companyDB; oCompany.UserName = userName; oCompany.Password = password; oCompany.language = SAPbobsCOM.BoSuppLangs.ln_English; if (string.IsNullOrEmpty(addonID) == false) { oCompany.AddonIdentifier = addonID; } oCompany.XmlExportType = SAPbobsCOM.BoXmlExportTypes.xet_ExportImportMode; lRetCode = oCompany.Connect(); DIErrHandler("Connectiong Company"); CompDB = oCompany.CompanyDB; } // If lRetCode <> 0 Then // oCompany.GetLastError() // End If catch (Exception ex) { throw ex; } }
public SAPbobsCOM.Company Connect(string pServer, string pDBName, string pDBUser, string pDBPassword, SAPbobsCOM.BoDataServerTypes pServerType, string pSAPUser, string pSAPPassword, ref int iErr) { if (pDBName == "") { iErr = 1; } if (iErr != 0) { return(null); } //oConnTrg = SQLDirect.oConnectToSql(txbDBServerTrg.Text, cmbSAPDBTrg.Text.Substring(0, cmbSAPDBTrg.Text.IndexOf(" - ")), txbDBUserTrg.Text, txbDBPassTrg.Text, true, bErr); oComp.Server = pServer; if (pServer == "") { oComp.Server = scServer; } oComp.DbUserName = pDBUser; if (pDBUser == "") { oComp.DbUserName = scSQLName; } oComp.DbPassword = pDBPassword; if (pDBPassword == "") { oComp.DbPassword = scSQLPass; } oComp.DbServerType = pServerType; //if (pServerType == null) oComp.DbServerType = SAPbobsCOM.BoDataServerTypes.dst_MSSQL2008; oComp.CompanyDB = pDBName; oComp.UserName = pSAPUser; if (pSAPUser == "") { oComp.UserName = scSAPName; } oComp.Password = pSAPPassword; if (pSAPPassword == "") { oComp.Password = scSAPPass; } iErr = oComp.Connect(); if (iErr == 0) { return(oComp); } else { DImsg.MessageERR(iErr, oComp.GetLastErrorDescription()); return(null); } }