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: 229
Registered: May 2007
Location: PAKISTAN
Senior Member
How To Connect Forms 6i with Micro soft Sql Server via odbc

Thanks
Faheem

Report message to a moderator

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: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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.

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 09 01:24:20 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.