Unable to connect to the oracle database through .net application.

[Ramesh]

string conString = "user id=perksmgr; password=rgmskrep; data
source=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST
= 180.25.10.2)(PORT = 1551)) ) (CONNECT_DATA = (SERVICE_NAME =
REKS816) )) " ;

con = new OracleConnection(conString);

Plese send me compleate details, how to connecto to the database.

ERROR IS LIKE THIS :- Invalid length for connection option 'data
source', maximum lenght is 128

after that i changed my connection string,
string is like this...

string conString = "user id=perksmgr; password=rgmskrep; max pool
size=20; min pool size=5; Data Source=TEST=(DESCRIPTION =
(ADDRESS =(PROTOCOL = TCP)(HOST = 180.25.10.2)(PORT = 1551))
(CONNECT_DATA = (SID = TEST1)))(CONNECT_TYPE = ( SERVER = DEDICATED)
));" ;

but again same error.

currently my databse version is 9.2 recently migrated. but im my local
system tns file is below.

Please send me answer as early as possible.

My tns file is -----

# D:\ORANT\NET80\ADMIN\TNSNAMES.ORA Configuration
File:\orant\net80\admin\tnsnames.ora
# Generated by Oracle Net8 Assistant

#TEST1 =
# (DESCRIPTION =
# (ADDRESS = (PROTOCOL = TCP)(HOST = 180.25.10.2)(PORT = 1551))
# (CONNECT_DATA = (SID = TIPE1))
# )

#TEST2 =
# (DESCRIPTION =
# (ADDRESS = (PROTOCOL = TCP)(HOST = 180.25.10.1)(PORT = 1561))
# (CONNECT_DATA = (SID = TEST2))
# )

#SUNORA =
# (DESCRIPTION =
# (ADDRESS = (PROTOCOL = TCP)(HOST = 128.130.11.10)(PORT = 1521))
# (CONNECT_DATA = (SID = tidc))
# )

#TII =
# (DESCRIPTION =
# (ADDRESS = (PROTOCOL = TCP)(HOST = 128.127.30.9)(PORT = 1521))
# (CONNECT_DATA = (SID = TII))
# )

#TICOS =
# (DESCRIPTION =
# (ADDRESS = (PROTOCOL = TCP)(HOST = 128.127.30.11)(PORT = 1521))
# (CONNECT_DATA = (SID = cos))
# )

#TICI =
# (DESCRIPTION =
# (ADDRESS = (PROTOCOL = TCP)(HOST = 180.25.1.150)(PORT = 1525))
# (CONNECT_DATA = (SID = tici))
# )

#PROD =
# (DESCRIPTION =
# (ADDRESS = (PROTOCOL = TCP)(HOST = 180.25.10.2)(PORT = 1595))
# (CONNECT_DATA = (SID = OPS2))
# )

#TIDC =
# (DESCRIPTION =
# (ADDRESS = (PROTOCOL = TCP)(HOST = 128.130.11.10)(PORT = 1521))
# (CONNECT_DATA = (SID = tidc))
# )

#PRODTEST =
# (DESCRIPTION =
# (ADDRESS = (PROTOCOL = TCP)(HOST = 180.25.10.2)(PORT = 1551))
# (CONNECT_DATA = (SID = TEST1))
# )

TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 180.25.10.2)(PORT = 1551))
(CONNECT_DATA = (SID = TEST1))
)

PROD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 180.25.10.21)(PORT = 1597))
(CONNECT_DATA = (SID = OPS3))
)

 

[Morten Wennevik]

Hi Ramesh,

http://www.connectionstrings.com/