OraFAQ Forum: Windows » Connect SQL server2005 with Forms6i

Home » Infrastructure » Windows » Connect SQL server2005 with Forms6i (win XP with SP3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Connect SQL server2005 with Forms6i [message #381052]

Thu, 15 January 2009 00:21

shadow24
Messages: 6
Registered: May 2006
Location: Oman

Junior Member

Hi Everybody

I have read must of the articles as well the other members who are posting an issue on how to get the connection work perfectly on oracle forms with SQL server. but in fact non of the members have post any clear guide on how to make the connection work proper..

Now let me explain in details what I have done. I am able to connect with SQL Server2005 by ODBC and i have no problem, i have tested it and it's successfully working
I have done this through the following steps
Start - Settings - Control Panel - Administrative Tools - Data Sources (ODBC)..

I set all the required setting and i tested the connection and it works ...

now when i am trying to connect through Oracle Forms6i Builder using the following connection string:oman/sql@odbc:AdventureWorks
Where : oman is the login user for Windows OS which is i am using because this is how I log in my laptop as well as I log in to SQL Server Management Studio to connect to SQL Server2005
sql is the password for my OS
AdventureWorks is the name of the Instance or let's the database name
so when i click on connect
the following error occurred: ORA-03121 no interface driver connected - function not performed....

My question is: am I typing something wrong on the string connection box?
or I should do something else in order to make the connection work??
or is there is something else still missing that I need to download like plug in or something to make this connection works

I appreciate your help if you can guide me further
thank you very much

P.S: please send me the replay to my direct e mail nss121@hotmail.com

Report message to a moderator

Re: Connect SQL server2005 with Forms6i [message #381121 is a reply to message #381052]

Thu, 15 January 2009 05:56

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

>>Connect SQL server2005 with Forms6i

Oh !!!. As per as i know; There is NO way to connect SQL Server from forms 6i.

I belive; If you try to connect database from forms 6i; It should be ask username/password@DBNAME (Not ODBC name)

Right

Babu

Report message to a moderator

Re: Connect SQL server2005 with Forms6i [message #396240 is a reply to message #381052]

Sun, 05 April 2009 08:34

aamiz
Messages: 1
Registered: March 2007
Location: Karachi, Pakistan

Junior Member

Hello, No you are wrong Babu..

we can connect form 6i with ODBC connection easily..
he is doing everything properly..

@shadow24
you have to install Forms 6i again in a properway!!

have u installed any patch lately.. because installing patch improperly creates this problem sometime,,,,

Login String : <USERNAME>/<PASSWORD>@ODBC:<ODBCNAME>

you can also use access odbc. like this

admin/admin@odbc:<access odbc name>

Report message to a moderator