Is there a way to use tnsnames.ora in Mobile?

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Jes_Gru
Posts: 1
Joined: Thu 11 Jun 2009 15:57

Is there a way to use tnsnames.ora in Mobile?

Post by Jes_Gru » Thu 11 Jun 2009 16:16

As IP addresses and ports can change is there a way to use tnsnames.ora file using the mobile version of dotConnect on a CE device?

So the connection string could be:

string connString = "Data Source=idbsdev;User ID=name;Password=password;";

instead of:

string connString = @"user id=name;Password=password;server=159.138.52.100;sid=idbsdev;port=1526;";

The tnsnames.ora entry is:

idbsdev.world =
(DESCRIPTION =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = mfgdev)
(Port = 1526)
)
(CONNECT_DATA =
(SID = idbsdev)
(GLOBAL_NAME = idbsdev.world)
)
)

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

Post by Shalex » Fri 12 Jun 2009 16:06

The tnsnames.ora file cannot be used on mobile devices because there is no appropriate mobile version of Oracle client. If you want to change the connection string dynamically, please place it to the *.config file of your application.

Post Reply