|
|
|
|
Re: very urgent - How to make connection to SQL Server [message #141600 is a reply to message #141497] |
Tue, 11 October 2005 03:04 |
maoro
Messages: 312 Registered: May 2005
|
Senior Member |
|
|
sorry for using abrevaiations its a bad habbit,
anyway i tried some things before posting the request
1-i created an odbc connection
2-i edited the listener file to create a new listener
3-i i edited the tnsnames.ora file
i created a database link
problems are : couldnt start the listener using lsnrctl
and the connect string to the sql server
im not sure if its got to be like
sqlplus>sa/sa@mysqlconnection ??
i request your help cause i am on a time farme limit
sorry
plus most of the post here applies to forms 6i
anyway thx for eveything
by the way the word "sux" is professional and not an abreviation for "sucks" !!!!
|
|
|
|
|
|
|
Re: very urgent - How to make connection to SQL Server [message #142011 is a reply to message #141497] |
Thu, 13 October 2005 02:33 |
maoro
Messages: 312 Registered: May 2005
|
Senior Member |
|
|
hi
well i managed to connect to sql server using heterogenious services , i created an odbc connection ,a listener ,edited the tnsname.ora file
but its not a reliable connection and its based on the oracle database server as you know
hopefully i can find help to connect forms 9i directely to sql server without the use of the oracle database
thx
|
|
|
|
Re: very urgent - How to make connection to SQL Server [message #142189 is a reply to message #141497] |
Thu, 13 October 2005 13:09 |
lupien1
Messages: 9 Registered: May 2005
|
Junior Member |
|
|
Hi,
With forms5 we install OCA (Open Client Adapter) for ODBC. The only thing to do is to use the connexion string when you logon with an Oracle product as the following:
username/pw@odbc:DNSNAME
Where DNSNAME is the datasource name you create with ODBC.
With OCA you can use Forms product and SQL*Plus. OCA is part of developer/2000 product. I don't know if it still available with newer Forms Product.
About the Heterogeneous Services, i have one create and working but not as you want. I can connect to an Oracle database and then using the dblink to query a table in a non-Oracle database with success, but i tried to connect SQL*Plus with username/pw@dblink and it didn't work and i'm not sure it can be done.
I hope this help you and please excuse my english!
|
|
|
|
|