Home » Developer & Programmer » Forms » connect 6i with MS Access  () 2 Votes
icon14.gif  connect 6i with MS Access [message #172723] Wed, 17 May 2006 14:19 Go to next message
shetu50
Messages: 4
Registered: April 2006
Location: lahore
Junior Member

Hello,
i want to connect the oracle 6i form with Mircosoft Access.
so tell me the procedure what i do..

thanks
Shakeel
Re: connect 6i with MS Access [message #172737 is a reply to message #172723] Wed, 17 May 2006 18:19 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
@others: Can we define an ODBC connection in tnsnames.ora?

David
Re: connect 6i with MS Access [message #172798 is a reply to message #172737] Thu, 18 May 2006 02:16 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
djmartin wrote on Thu, 18 May 2006 01:19

@others: Can we define an ODBC connection in tnsnames.ora?
Yes we can. I have even connected an Oracle to a Excel workbook (I could access each sheet as if it were a table) for demonstration purposes.

Anyway, have a look at HSODBC or Heterogenous Services Wink Unfortunately I'm not at my regular client right now (where I have documented it in a nice step-by-step document) but here are some links:
link 1
link 2
link 3

Hey, doesn't Forms6i have the Open Client Adapter (OCA)?

MHE
Re: connect 6i with MS Access [message #172799 is a reply to message #172798] Thu, 18 May 2006 02:19 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Maaher wrote on Thu, 18 May 2006 09:16

Hey, doesn't Forms6i have the Open Client Adapter (OCA)?
Yes it has. Search your Forms installation for 'oca_info.pdf' or have a look at Metalink Note:1026527.6.

MHE
Re: connect 6i with MS Access [message #172862 is a reply to message #172799] Thu, 18 May 2006 07:13 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Maarten, thanks, I'm going to 'rate' this question and add its link to my list of 'hot' answers.

David
Re: connect 6i with MS Access [message #395137 is a reply to message #172723] Tue, 31 March 2009 08:00 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan
Senior Member

sir,
I need detail steps of connecting form to ms access.
bcs i still unable to connect the form to ms access.
tell me in detail steps.
Thanks
Re: connect 6i with MS Access [message #395518 is a reply to message #395137] Wed, 01 April 2009 13:16 Go to previous message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Maarten has already provided all steps in one of previous discussions. Search the board for "ODBC" in the "Forms" forum; author is "Maaher". Read all you find.
Previous Topic: how to get week number as per financial year starts & end
Next Topic: Java bean
Goto Forum:
  


Current Time: Fri Dec 02 23:15:34 CST 2016

Total time taken to generate the page: 0.07936 seconds