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!