Page 1 of 1

Oracle windows7

Posted: Thu 15 Apr 2010 14:34
by aspirany
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

Posted: Fri 16 Apr 2010 14:14
by Shalex
Please give us the following information:
1) OracleException.Message, OracleException.InnerException and OracleException.StackTrace;
2) have you put the content of the folder with instant client to the folder with your application *.exe file?
3) the version of your dotConnect for Oracle. You can find it in the Tools > Oracle > About menu of Visual Studio;
4) the version of your Visual Studio. You can find it in the Help > About menu of Visual Studio.