Home » Other » General » Heterogeneous Connection to Microsaft Access Database
Heterogeneous Connection to Microsaft Access Database [message #197655] Thu, 12 October 2006 03:40 Go to next message
idroza
Messages: 4
Registered: July 2006
Junior Member
I have successfulyl configure Oracle to access a remote Microsoft Access Database using the HS service and I can do selects and see the tables. But When I try to do an insert I get the error
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message
[Generic Connectivity Using ODBC][Microsoft][ODBC Microsoft Access Driver]
Operation must use an updateable query. (SQL State: 00000; SQL Code: -3035)
ORA-02063: preceding 2 lines from ACCESS1


I have checked the Acess databse and it is not read only .
Can any one help
Re: Heterogeneous Connection to Microsaft Access Database [message #197830 is a reply to message #197655] Thu, 12 October 2006 19:37 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
If you were using Oracle Forms I would say that you haven't told the form to use the correct 'key mode'. Is there a 'key mode' attribute when defining an ODBC source to Oracle?

David
Re: Heterogeneous Connection to Microsaft Access Database [message #197840 is a reply to message #197830] Thu, 12 October 2006 20:14 Go to previous messageGo to next message
idroza
Messages: 4
Registered: July 2006
Junior Member
I am not using oracle forms I am using plsql
Re: Heterogeneous Connection to Microsaft Access Database [message #197853 is a reply to message #197840] Thu, 12 October 2006 23:04 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Look at http://www.minisoft.com/pages/middleware/ODBC_UNIX/odbc_oracle_faq.htm (do a find on '02063') and http://www.datadirect.com/developer/odbc/oracle_heterogeneous/index.ssp (do a find on '02063') and http://www.datadirect.com/developer/odbc/docs/oracle_hs.pdf (again do a find on '02063').

David
Re: Heterogeneous Connection to Microsaft Access Database [message #197857 is a reply to message #197853] Thu, 12 October 2006 23:17 Go to previous messageGo to next message
idroza
Messages: 4
Registered: July 2006
Junior Member
David,
Thanks for the input. I will read up on it , as I am usre it will give me some added knowledge.
I have since solved the puzzle.
The problem was that the Acess database was sitting in a different domain , once I moved it to the same domain in which the database was running I was able to update.
Thank you once again for your time and advice
Re: Heterogeneous Connection to Microsaft Access Database [message #217776 is a reply to message #197655] Mon, 05 February 2007 07:25 Go to previous message
lama_naim
Messages: 7
Registered: April 2006
Location: Kuwait
Junior Member

Can you please send me in details what you have done to insert data from oracle database to Microsoft Access database?
i do appreciate ur help
Previous Topic: using expired products license problem
Next Topic: Basics of Oracle Financials Implementation
Goto Forum:
  


Current Time: Sun Dec 04 04:15:34 CST 2016

Total time taken to generate the page: 0.10470 seconds