Home » Developer & Programmer » Forms » Can we connect Forms 6i with Sql server (forms 6.0.8.11.3,sql server2000)
Can we connect Forms 6i with Sql server [message #278338] Sat, 03 November 2007 01:53 Go to next message
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
Re: Can we connect Forms 6i with Sql server [message #279534 is a reply to message #278338] Thu, 08 November 2007 22:59 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Re: Can we connect Forms 6i with Sql server [message #280044 is a reply to message #279534] Mon, 12 November 2007 06:24 Go to previous messageGo to next message
naresh090183
Messages: 6
Registered: November 2007
Location: Chenai
Junior Member
Hi david,

Am unable to connect.Can u suggest me any solutions.

Regards,
Naresh Kumar Murali
Re: Can we connect Forms 6i with Sql server [message #280089 is a reply to message #280044] Mon, 12 November 2007 07:46 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Do you have an ODBC system DSN to the SQL server database? A database link to a foreign data source should be configured on the server, doesn't it? So changing your Forms Oracle home won't help very much, I'm afraid.

Perhaps this link helps:
http://www.databasejournal.com/features/oracle/article.php/10893_3442661_1

MHE
Previous Topic: On query_execute which triggers will file
Next Topic: how can i pass block name to procedure
Goto Forum:
  


Current Time: Sat Dec 10 10:59:36 CST 2016

Total time taken to generate the page: 0.08851 seconds