Oracle dotConnect Mobile Edition Direct Mode?

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
davermcl
Posts: 6
Joined: Wed 21 Jan 2009 17:37

Oracle dotConnect Mobile Edition Direct Mode?

Post by davermcl » Wed 21 Jan 2009 17:42

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

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Wed 21 Jan 2009 17:54

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.

davermcl
Posts: 6
Joined: Wed 21 Jan 2009 17:37

Post by davermcl » Wed 21 Jan 2009 18:00

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

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Thu 22 Jan 2009 07:49

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.

davermcl
Posts: 6
Joined: Wed 21 Jan 2009 17:37

Post by davermcl » Thu 22 Jan 2009 15:56

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

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Thu 22 Jan 2009 16:33

Please give us the connection string you are using.

davermcl
Posts: 6
Joined: Wed 21 Jan 2009 17:37

Post by davermcl » Thu 22 Jan 2009 16:37

Connection String:

Data Source=dbserver;SID=ORAEMD.WORLD;User Id=EASYUSER9;Password=doorman

BTW, it works on another Oracle client.

David

davermcl
Posts: 6
Joined: Wed 21 Jan 2009 17:37

Post by davermcl » Thu 22 Jan 2009 16:51

It works if I set the SID in the connection string to "ORAEMD".

Do you know why this is?

davermcl
Posts: 6
Joined: Wed 21 Jan 2009 17:37

Post by davermcl » Thu 22 Jan 2009 17:02

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!

Post Reply