Log in

View Full Version : Pocket PC to Desktop Oracle


DannyZ
02-19-2008, 03:59 PM
Hi.
I am trying to connect desktop ORacle Server( oracle 11g) from my Windows Mobile 5 Pocket PC, I used Oracle.DAtaAccess.Lite to do this. I am using Visual Studio.Net 2005 C# smartdevice e.
the code in my project

OracleConnection con = new OracleConnection("Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl)));uid=HBYS;pwd=masterkey;");
OracleCommand cmd = new OracleCommand("select * from yat_Pol", con);
OracleDataAdapter adap = new OracleDataAdapter(cmd);
adap.Fill(ds,"ypol");
dataGrid1.DataSource = ds.Tables["ypol"];

I tried OraDİrect Commponent but its trial. I cant use it. There is a solution for my problem. Please help