Home » Developer & Programmer » Forms » very urgent - How to make connection to SQL Server
very urgent - How to make connection to SQL Server [message #141497] Mon, 10 October 2005 09:32 Go to next message
maoro
Messages: 312
Registered: May 2005
Senior Member
guys i really need ur help over this
i want to connect to an sql server using forms 9i
plz plz
my job depends on it now Embarassed
it would be a huge favor
a small fmb file would be awesome
thx for everyone
especially MR David for hes gr8 participation

[Updated on: Mon, 10 October 2005 18:36] by Moderator

Report message to a moderator

Re: very urgent [message #141500 is a reply to message #141497] Mon, 10 October 2005 10:04 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Have you read this thread?

Have you also searched the board? Look for ODBC.

MHE

[Updated on: Mon, 10 October 2005 10:05]

Report message to a moderator

Re: very urgent [message #141549 is a reply to message #141497] Mon, 10 October 2005 18:34 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
marwan,

Please stop the IM speak and tell us what you can't get working. There are some very, very good threads in this forum. IF you had searched on 'ODBC' and you would have found http://www.orafaq.com/forum/m/123024/67467/?srch=odbc#msg_123024 which points to http://www.orafaq.com/forum/t/45237/68619/. This thread HAS a sample form in it.

Please, help us help you, by helping yourself, first.

David

Report message to a moderator

Re: very urgent - SQL Server connection [message #141550 is a reply to message #141497] Mon, 10 October 2005 18:35 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
By the way, your title 'sux'.

David

Report message to a moderator

Re: very urgent - How to make connection to SQL Server [message #141600 is a reply to message #141497] Tue, 11 October 2005 03:04 Go to previous messageGo to next message
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" !!!!

Report message to a moderator

Re: very urgent - How to make connection to SQL Server [message #141725 is a reply to message #141600] Tue, 11 October 2005 17:46 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Truely?? What does 'sux' stand for, if not 'sucks'.

David

Report message to a moderator

Re: very urgent - How to make connection to SQL Server [message #141752 is a reply to message #141600] Tue, 11 October 2005 23:25 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Quote:

problems are : couldnt start the listener using lsnrctl

What message do you get?

There is a facility called 'ODBCtest' for testing access to ODBC sources. Can you find it? Does it access your ODBC source successfully?

David

[Updated on: Tue, 11 October 2005 23:26]

Report message to a moderator

Re: very urgent - How to make connection to SQL Server [message #141797 is a reply to message #141497] Wed, 12 October 2005 03:36 Go to previous messageGo to next message
maoro
Messages: 312
Registered: May 2005
Senior Member
no i didnt try to use odbctest
can u pass me some instructions over using it
thx

Report message to a moderator

Re: very urgent - How to make connection to SQL Server [message #141947 is a reply to message #141797] Wed, 12 October 2005 19:51 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
On my machine, it is 'Start > Programs > Data Sources (ODBC)'. It will open on 'User DSN - User Data Sources', if you have an Oracle entry - good, else press 'Add', find the Oracle in the List, if it is not there then you didn't install the ODBC bits when you installed Oracle (you will have to run the Oracle installer again and select the ODBC bits and install them - no biggy). From the TNS Service Name pick your environment, give it a 'Data Source Name' and 'Description' and 'User ID'. Press 'Test Connection'. Does it work, good. No, then do you have 'periods' in your tnsnames.ora entry - ODBC will only show the first 'part' - you need to add the period and extra segments to the 'TNS Service Name'.

Try this and get back to us.

David

Report message to a moderator

Re: very urgent - How to make connection to SQL Server [message #142011 is a reply to message #141497] Thu, 13 October 2005 02:33 Go to previous messageGo to next message
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

Report message to a moderator

Re: very urgent - How to make connection to SQL Server [message #142013 is a reply to message #142011] Thu, 13 October 2005 02:39 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Sorry ... I drifted off your topic. You don't want ODBC access to Oracle.

Okay, what is wrong with the sample form associated with the link I gave you previously?

David

Report message to a moderator

Re: very urgent - How to make connection to SQL Server [message #142189 is a reply to message #141497] Thu, 13 October 2005 13:09 Go to previous messageGo to next message
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!

Report message to a moderator

Re: very urgent - How to make connection to SQL Server [message #142215 is a reply to message #142189] Thu, 13 October 2005 18:14 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Mlupien,

Thanks for your contribution.

David
Keyword: ODBC

Report message to a moderator

Re: very urgent - How to make connection to SQL Server [message #142299 is a reply to message #141497] Fri, 14 October 2005 01:58 Go to previous message
maoro
Messages: 312
Registered: May 2005
Senior Member
thx for your help guys

i guess with forms 9i there is no reliable solution without using the oracle database server as a bridge
and its not reliable at all
have a nice time

Report message to a moderator

Previous Topic: How to start Oracle Terminal
Next Topic: associating keys with triggers
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 00:47:23 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.