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

[Ramesh]

string conString = "user id=perksmgr; password=rgmskr ep; data
source=(DESCRIP TION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST
= 180.25.10.2)(PO RT = 1551)) ) (CONNECT_DATA = (SERVICE_NAME =
REKS816) )) " ;

con = new OracleConnectio n(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=rgmskr ep; max pool
size=20; min pool size=5; Data Source=TEST=(DE SCRIPTION =
(ADDRESS =(PROTOCOL = TCP)(HOST = 180.25.10.2)(PO RT = 1551))
(CONNECT_DATA = (SID = TEST1)))(CONNEC T_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:D:\orant\n et80\admin\tnsn ames.ora
# Generated by Oracle Net8 Assistant

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

#TEST2 =
# (DESCRIPTION =
# (ADDRESS = (PROTOCOL = TCP)(HOST = 180.25.10.1)(PO RT = 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)(P ORT = 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)(P ORT = 1525))
# (CONNECT_DATA = (SID = tici))
# )

#PROD =
# (DESCRIPTION =
# (ADDRESS = (PROTOCOL = TCP)(HOST = 180.25.10.2)(PO RT = 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)(PO RT = 1551))
# (CONNECT_DATA = (SID = TEST1))
# )

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

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

[Morten Wennevik]

Hi Ramesh,

http://www.connectionstrings.com/

--
Happy Coding!
Morten Wennevik [C# MVP]