/// <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);
}
