With Oracle.DataAccess.Lite_wce.dll i want to ceonnect to oracle database.
I try like:
OracleConnection conn = new OracleConnection("Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=baza1)));User Id=xx;Password=xx;");
but it said "S1000[POL-3023] the database does not exist".
What i am doing wrong?
what client are you using if you are using windows mobile then
Oracle.DataAccess.Lite.dll on the handheld
connection string is "dsn=databasename;uid=SYSTEM;pwd=userpassword"
the username is always system, the passw0rd the the user password of the specific user that the handheld is created for, the database name depends you can see it in the device->orace->odbc.txt file
if your re on c# then you should write
OraCon = new LiteConnection(connectionstring);
the connection string you mention seems like the ones we use on oracle database server like 11g for example. there you have a database server with a listener , this is why you set host port etc. in the oracle client clients there is no server. it is lighter, this is why for exampl you use the odbc style to connect to the windows mobile.