Код: Выделить всё
PrivateKeyFile keyFile = new PrivateKeyFile(@"D:\ssh.ppk");
var keyFiles = new[] { keyFile };
var username = "Admin";
var methods = new List();
methods.Add(new PrivateKeyAuthenticationMethod(username, keyFiles));
var con = new ConnectionInfo("abc.xyz.net", 22, username, methods.ToArray());
using (var client = new SshClient(con))
{
client.Connect();
if (client.IsConnected)
{
var portForwarded = new ForwardedPortLocal("127.0.0.1", 3306, "127.0.0.1", 3306);
client.AddForwardedPort(portForwarded);
portForwarded.Start();
var connectionString = "DATA SOURCE=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=3306)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ABC_DB)));PASSWORD=myPassword;USER ID=myUsername";
//var connectionString = "DATA SOURCE=127.0.0.1:3306/ABC_DB;PASSWORD=myPassword;USER ID=myUsername";
using (OracleConnection conn = new OracleConnection(connectionString))
{
//conn.Open();
using (OracleCommand com = new OracleCommand("SELECT * FROM Table_Name", conn))
{
com.CommandType = CommandType.Text;
DataSet ds = new DataSet();
OracleDataAdapter da = new OracleDataAdapter(com);
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}
}
client.Disconnect();
}
else
{
Console.WriteLine("Client cannot be reached...");
}
}
Помогите пожалуйста, если знаете какие настройки нужно изменить, где.
Заранее спасибо.
Подробнее здесь: https://stackoverflow.com/questions/404 ... um-failure
Мобильная версия