Home » Infrastructure » Windows » Connect SQL server2005 with Forms6i (win XP with SP3)
Connect SQL server2005 with Forms6i [message #381052] Thu, 15 January 2009 00:21 Go to next message
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
Re: Connect SQL server2005 with Forms6i [message #381121 is a reply to message #381052] Thu, 15 January 2009 05:56 Go to previous messageGo to next message
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
Re: Connect SQL server2005 with Forms6i [message #396240 is a reply to message #381052] Sun, 05 April 2009 08:34 Go to previous messageGo to next message
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>
Re: Connect SQL server2005 with Forms6i [message #396247 is a reply to message #396240] Sun, 05 April 2009 13:35 Go to previous messageGo to next message
ora_baby
Messages: 89
Registered: May 2008
Member
http://www.orafaq.com/forum/m/394989/124740/?srch=connect+access#msg_394989

in your case you have sql server 2005

[Updated on: Sun, 05 April 2009 13:36]

Report message to a moderator

Re: Connect SQL server2005 with Forms6i [message #396347 is a reply to message #396247] Mon, 06 April 2009 04:29 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

@aamiz,

Thanks for catching..

Babu
Previous Topic: Setting datestamp on export file
Next Topic: SQL Statement inside DOS Bat File
Goto Forum:
  


Current Time: Fri Mar 29 07:10:16 CDT 2024