OraFAQ Forum: Forms » How to connect Oracle Forms to MS Access Database and SQL Server?

Home » Developer & Programmer » Forms » How to connect Oracle Forms to MS Access Database and SQL Server?

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

How to connect Oracle Forms to MS Access Database and SQL Server? [message #85199]

Wed, 09 June 2004 00:02

Next
Messages: 2
Registered: June 2004

Junior Member

How to connect Oracle Forms to MS Access Database and SQL Server?

Report message to a moderator

Re: How to connect Oracle Forms to MS Access Database and SQL Server? [message #85210 is a reply to message #85199]

Wed, 09 June 2004 08:07

Tak Tang
Messages: 142
Registered: May 2004

Senior Member

If you are using Forms 6(i), you could install the Open Client Adaptor, which lets you use ODBC from Forms. You can find OCA on your install discs. There is also an example on http://www.geocities.com/oranails.

If you are using Oracle Server 8/9/10, you could use Generic Connectivity option of Hetrogeneous Services, which allows the Oracle Server to connect to ODBC sources over a database link. I did a worked example with an Excel spread sheet on http://asktom.oracle.com/pls/ask/f?p=4950:61:15738880224844462205::::P61_ID:4406708207206#18830681837358

You might be able to use Ole Automation on the Forms side to connect to, and drive MS Access or SQL Server. I had a look and couldnt make sense of it.

Tak

Report message to a moderator

Re: How to connect Oracle Forms to MS Access Database and SQL Server? [message #85222 is a reply to message #85210]

Wed, 09 June 2004 23:38

Next
Messages: 2
Registered: June 2004

Junior Member

Thanks a lot.
I'll try.

Report message to a moderator

Re: How to connect Oracle Forms to MS Access Database and SQL Server? [message #85313 is a reply to message #85199]

Tue, 15 June 2004 06:10

sreelatha
Messages: 3
Registered: December 2000

Junior Member

I want to know how to connect oracle data to

ms access and if the data is large i.e upto

some 9000 records.
And also can we view that huge data in oracle i.e

any command is there or not.

thanking u.

Report message to a moderator

Previous Topic:	Date's difference
Next Topic:	Help me with date and datetime items!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 07 04:01:56 CDT 2024