Devart Forums

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)
)
)

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.