| Can we connect Forms 6i with Sql server [message #278338] |
Sat, 03 November 2007 01:53  |
naresh090183
Messages: 6
Registered: November 2007
Location: Chenai
|
Junior Member |
|
|
Hi to all
Can v connect forms 6i with sql server 2000.This time google doesn't helped me.I have configured tns.ora and listener in forms but when connecting error resembles (nolistener found).
Since I have not connected oracle with sqlserver i cant find any solutions.Please help in this regard.
My configuration settings are..
(FORMS)TNS:
MYSQL =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=<server_name>)(PORT=1522))
(CONNECT_DATA=(SID=<dns_name>))
(HS=OK)
)
(FORMS)LISTENER:
LISTENERMYSQL =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=<server_name>)(PORT=1522))
(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))
SID_LIST_LISTENERMYSQL=
(SID_LIST=
(SID_DESC=
(SID_NAME=<domain_name>)
(ORACLE_HOME = d:\ORACLE)
(PROGRAM=hsodbc)
)
)
Regards,
Naresh Kumar Murali
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
