Oracle windows7
Posted: Thu 15 Apr 2010 14:34
Hi every body!
I would like use devart product under windows7.I download instant client
but i don't what i do.
if some one can read a litle sample code
Like this:
OracleConnection conn = new OracleConnection();
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
string oradb = "Data Source=(DESCRIPTION=(ADDRESS_LIST="
+ "(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.127.133)(PORT=1521)))"
+ "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCL10)));"
+ "User Id=scott;Password=tiger;";
try
{
conn.ConnectionString = oradb;
/*conn.Password = "tiger";
conn.Server = "192.168.127.133";
conn.UserId = "scott";
conn.Sid = "ORCL10";
conn.Port = 1521;
conn.Direct = true;*/
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
}
catch (OracleException ex)
{
MessageBox.Show(ex.ToString());
}
}
i cant connect to the server
Thanks
I would like use devart product under windows7.I download instant client
but i don't what i do.
if some one can read a litle sample code
Like this:
OracleConnection conn = new OracleConnection();
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
string oradb = "Data Source=(DESCRIPTION=(ADDRESS_LIST="
+ "(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.127.133)(PORT=1521)))"
+ "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCL10)));"
+ "User Id=scott;Password=tiger;";
try
{
conn.ConnectionString = oradb;
/*conn.Password = "tiger";
conn.Server = "192.168.127.133";
conn.UserId = "scott";
conn.Sid = "ORCL10";
conn.Port = 1521;
conn.Direct = true;*/
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
}
catch (OracleException ex)
{
MessageBox.Show(ex.ToString());
}
}
i cant connect to the server
Thanks