Page 1 of 1
Oracle dotConnect Mobile Edition Direct Mode?
Posted: Wed 21 Jan 2009 17:42
by davermcl
Does dotConnect for Oracle Mobile Edition support Direct Mode? I just downloaded the trial on 1/20/09 (ver 5.0.12.1), and I don't see a Direct property on the OracleConnection class and get an error when setting this is the connection string. The documentation says it's supported.
Thanks
David
Posted: Wed 21 Jan 2009 17:54
by Shalex
Mobile Edition doesn't use Oracle client software, it can work only in Direct mode (the Direct property is always set to true). That's why it is not allowed to set/change this property in the connection string.
Posted: Wed 21 Jan 2009 18:00
by davermcl
Ok, thanks for the quick response!
I'm having another problem. I'm getting this error when calling OracleConnection.Open:
Network error:: An unknown, invalid, or unsupported option or level was specified in a getsockopt or setsockopt call
This is my connection string:
Data Source=dbserver;SID=ORAEMD.WORLD;User Id=ERDAUSER;Password=ERDAUSER
Thanks
David
Posted: Thu 22 Jan 2009 07:49
by Shalex
The new build (5.0.20.2) of dotConnect for Oracle Mobile is available now.
You can download it from here:
http://www.devart.com/dotconnect/oracle/dcoraclemob.exe . This build must be without the mentioned problem. Please try using it and notify us about the results.
Posted: Thu 22 Jan 2009 15:56
by davermcl
I installed the new version and now there is a new error msg:
NET: Invalid SID
This is the entry in tnsnames.ora:
ORAEMD.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.171.110)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORAEMD.WORLD)
)
)
Thanks for your help,
David
Posted: Thu 22 Jan 2009 16:33
by Shalex
Please give us the connection string you are using.
Posted: Thu 22 Jan 2009 16:37
by davermcl
Connection String:
Data Source=dbserver;SID=ORAEMD.WORLD;User Id=EASYUSER9;Password=doorman
BTW, it works on another Oracle client.
David
Posted: Thu 22 Jan 2009 16:51
by davermcl
It works if I set the SID in the connection string to "ORAEMD".
Do you know why this is?
Posted: Thu 22 Jan 2009 17:02
by davermcl
I did some research and I thought that the sid was the same as the service name in tnsnames.ora. But the sid is the name of the database instance.
Thanks for your great support!