Home » Developer & Programmer » Forms » Connecting MS-Access through Developer 2000 forms
Connecting MS-Access through Developer 2000 forms [message #77725] Wed, 07 November 2001 20:29 Go to next message
Asish Das
Messages: 2
Registered: November 2001
Junior Member
how to connect MS-ACCESS database in through Oracle Developer-2000 forms

----------------------------------------------------------------------
Re: Connecting MS-Access through Developer 2000 forms [message #77734 is a reply to message #77725] Thu, 08 November 2001 09:29 Go to previous messageGo to next message
Clint Garrett
Messages: 2
Registered: November 2001
Junior Member
Can't be done. Oracle forms only work on oracle database. Sorry

----------------------------------------------------------------------
Re: Connecting MS-Access through Developer 2000 forms [message #77771 is a reply to message #77725] Thu, 15 November 2001 09:19 Go to previous messageGo to next message
Surendra K
Messages: 8
Registered: September 2000
Junior Member
Hi Ashish,

Create an ODBC through control panel - > ODBC and use Microsoft Access Driver to establish connectivity to the directory where your Access Database file is stored.

In Forms Developer use Procedures and functions of EXEC_SQL package to connect,retrieve the records from MS Access. After retrieving these use the normal Insert command to insert into Oracle database. Go through Forms help for more details.

I hope u got an idea.

Let me know and if required i can send you the code.

Cheers.
Surendra

----------------------------------------------------------------------
Re: Connecting MS-Access through Developer 2000 forms [message #77781 is a reply to message #77725] Fri, 16 November 2001 20:14 Go to previous messageGo to next message
Asish Das
Messages: 2
Registered: November 2001
Junior Member
Dear Surendra,
sorry i could not establish the connection. Kindly send me the codes for
reference.
Thanks a lot.
Asish

----------------------------------------------------------------------
Re: Connecting MS-Access through Developer 2000 forms [message #78564 is a reply to message #77725] Sun, 03 March 2002 17:52 Go to previous messageGo to next message
James
Messages: 120
Registered: June 2000
Senior Member
Oracle forms will work with any level 2 ODBC compliant database, no?

I'm working on creating a database link to the access and SQLSERVER 7 that my venders use so I can just use the select * from name@odbc_database_link. I'm having problems setting up the name and listner. any input would be appreciated
how i can insert into MS Access from Oracle Developer 2000 [message #79264 is a reply to message #77771] Mon, 20 May 2002 15:26 Go to previous messageGo to next message
Gurvinder
Messages: 1
Registered: May 2002
Junior Member
thanks for above help
please help me on following with examples:

1)how i can insert into MS Access from Oracle Developer 2000
2) how to update
Re: Connecting MS-Access through Developer 2000 forms [message #80651 is a reply to message #77734] Sat, 26 October 2002 07:20 Go to previous message
Sanjay Krishna Das
Messages: 4
Registered: October 2002
Junior Member
No Message Body
Previous Topic: Forms 4.5 / Reports 2.5 Compatibilty with Oracle 9i
Next Topic: forms6i
Goto Forum:
  


Current Time: Wed Oct 27 04:32:14 CDT 2021