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