public void Execute_InvalidBackupServerCommand_ThrowsAseException_Sap()
{
using (var connection = new Sybase.Data.AseClient.AseConnection(ConnectionStrings.Pooled))
{
var dbName = connection.QuerySingle <string>("select db_name()");
var ex = Assert.Throws <Sybase.Data.AseClient.AseException>(() => connection.Execute($"dump database {dbName} to '/doesnotexist/foo' with compression = '101'"));
Assert.Greater(ex.Errors.Count, 1);
Assert.Greater(ex.Errors[0].Severity, 10);
}
}
public SybaseASE()
{
Console.WriteLine("Creating Sybase.Data.AseClient.AseConnectionObject");
try
{
var obj = new Sybase.Data.AseClient.AseConnection();
Console.WriteLine("SUCCESS!");
}
catch (Exception ex)
{
Console.WriteLine("FAILED");
Console.WriteLine(ex.Message);
}
}
public IDbConnection CreateConnection()
{
IDbConnection conn = null;
if (ClientType.ctMsSql == DbType)
{
conn = new SqlConnection(ConnectionString);
}
else if (ClientType.ctOleDB == DbType)
{
conn = new OleDbConnection(ConnectionString);
}
else if (ClientType.ctOracle == DbType)
{
conn = new OracleConnection(ConnectionString);
if (conn.State == ConnectionState.Closed) conn.Open();
OracleTransaction tran = conn.BeginTransaction(IsolationLevel.Unspecified) as OracleTransaction;
tran.Commit();
conn.Close();
}
else if (ClientType.ctODBC == DbType)
{
conn = new OdbcConnection(ConnectionString);
}
#if MySql
else if (ClientType.ctMySql == DbType)
{
conn = new MySql.Data.MySqlClient.MySqlConnection(ConnectionString);
}
#endif
#if Informix
else if (ClientType.ctInformix == DbType)
{
conn = new IBM.Data.Informix.IfxConnection(ConnectionString);
if (conn.State == ConnectionState.Closed) conn.Open();
var command = conn.CreateCommand();
command.CommandText = "EXECUTE PROCEDURE ifx_allow_newline ('t')";
command.ExecuteNonQuery();
}
#endif
#if Sybase
else if (ClientType.ctSybase == DbType)
{
conn = new Sybase.Data.AseClient.AseConnection(ConnectionString);
}
#endif
else
{
throw new EEPException(EEPException.ExceptionType.MethodNotSupported, this.GetType(), null, "CreateConnection", null);
}
return conn;
}