/// <summary> /// Converts ODBC connection string to the SQL Client (.NET). /// </summary> public static string OdbcToSqlClient(this string odbcString) { if (string.IsNullOrEmpty(odbcString)) { return null; } try { var odbc = new OdbcConnectionStringBuilder(odbcString); var server= odbc.GetValue(OdbcServerKey); var database = odbc.GetValue(OdbcDatabaseKey); if (!string.IsNullOrWhiteSpace(server) && !string.IsNullOrWhiteSpace(database)) { var sql = new SqlConnectionStringBuilder(); sql.DataSource = server; sql.InitialCatalog = database; if (odbc.ContainsKey(OdbcUidKey)) { //Standard Connection sql.IntegratedSecurity = false; sql.UserID = odbc.GetValue(OdbcUidKey); sql.Password = odbc.GetValue(OdbcPasswordKey); } else { //Trusted Connection sql.IntegratedSecurity = true; } return sql.ConnectionString; } } catch(ArgumentException) { } return null; }
public static string GetValue(this string odbcString, string key) { var odbc = new OdbcConnectionStringBuilder(odbcString); return odbc.GetValue(key); }