Home » Developer & Programmer » Forms » How To Connect Forms 6i with Micro soft Sql Server via odbc
How To Connect Forms 6i with Micro soft Sql Server via odbc [message #262212] Sat, 25 August 2007 02:15 Go to next message
qanita786
Messages: 213
Registered: May 2007
Location: PAKISTAN
Senior Member
How To Connect Forms 6i with Micro soft Sql Server via odbc

Thanks
Faheem
Re: How To Connect Forms 6i with Micro soft Sql Server via odbc [message #262411 is a reply to message #262212] Mon, 27 August 2007 00:03 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Create the 'odbc' link and use it. Sorry, unless you can let us know what problem you are having with Forms and ODBC there is nothing else to say other than read the help screens for setting up a new ODBC link and then adding it to the tnsnames.ora file. Use SQL*Plus to test the odbc link.

David
Re: How To Connect Forms 6i with Micro soft Sql Server via odbc [message #262425 is a reply to message #262212] Mon, 27 August 2007 00:38 Go to previous message
hemavb
Messages: 103
Registered: May 2007
Location: Dubai , UAE
Senior Member
create an ODBC connection on the MS SQL server.
when you log in from forms use...

USERNAME > (from your SQL server)
PASSWORD > (from your SQL server)
DATABASE > odbc:(odbcname)

However, you have to have OCA installed with your FOrms.
Previous Topic: Opening Reports 9i from Forms 9i *it was working fine on other laptop*
Next Topic: Not able to run the forms
Goto Forum:
  


Current Time: Fri Dec 09 04:19:17 CST 2016

Total time taken to generate the page: 0.12639 seconds