Access frontal interface for Oracle database
in [Oracle Help]
|
Prev: Jobs, Interview Questions, Certification, Knowledge
Next: Dynamic PL/SQL - Get values from one cursor from another or alternatives?
From: Gloops on 9 Aug 2008 17:53 Hello everybody, Is anyone able to give me some indications about how to develop an Access interface for an Oracle database ? I dispose of Access 2003 (11.6566.8107) SP2, Oracle 9i 9.2.0.1.0 and ODBC 3.525.1117.0, on Windows XP Pro 5.1.2600 SP2 Nu 2600. I failed executing an Oracle stored procedure from Access, and a trigger to store data to a temporary table was active from SQL*Plus, but not from Access. So, my access base can connect one user, not a hundred as requested. Anybody ?
From: gym dot scuba dot kennedy at gmail on 9 Aug 2008 21:15 "Gloops" <gloops(a)invalid.zailes.org> wrote in message news:g7l3k5$fi8$1(a)aioe.org... > Hello everybody, > > Is anyone able to give me some indications about how to develop an Access > interface for an Oracle database ? > > I dispose of Access 2003 (11.6566.8107) SP2, Oracle 9i 9.2.0.1.0 and ODBC > 3.525.1117.0, on Windows XP Pro 5.1.2600 SP2 Nu 2600. > > I failed executing an Oracle stored procedure from Access, and a trigger > to store data to a temporary table was active from SQL*Plus, but not from > Access. > > So, my access base can connect one user, not a hundred as requested. > Anybody ? Don't use temporary tables. Oracle!=MS Sql Server You would probably have to use a pass through query to do a stored proc.
From: Gloops on 10 Aug 2008 04:57 gym dot scuba dot kennedy at gmail a écrit, le 10/08/2008 03:15 : >> I failed executing an Oracle stored procedure from Access > You would probably have to use a pass through query to do a stored proc. Well, would you mind giving a few details ?
From: gym dot scuba dot kennedy at gmail on 10 Aug 2008 09:34 "Gloops" <gloops(a)invalid.zailes.org> wrote in message news:g7mah7$9m0$1(a)aioe.org... gym dot scuba dot kennedy at gmail a �crit, le 10/08/2008 03:15 : >> I failed executing an Oracle stored procedure from Access > You would probably have to use a pass through query to do a stored proc. Well, would you mind giving a few details ? I haven't used access in many years. This is my best guess. Did you do a search for an example similar to the one you are trying to do? Jim
From: Gloops on 10 Aug 2008 10:06
gym dot scuba dot kennedy at gmail a écrit, le 10/08/2008 15:34 : > >> Well, would you mind giving a few details ? > I haven't used access in many years. This is my best guess. Did you do a > search for an example similar to the one you are trying to do? Of course I did, I should very pleased to learn that your search appears more efficient ... The Execute method (of ADODB ? not sure I remember, I have a look tomorrow) can execute, on Oracle, commands INSERT, DELETE, UPDATE, but not EXECUTE, I could not execute a stored procedure in Oracle that way. I searched "Access Oracle ODBC", do you see a better search ? I have to admit I only had a look to the ten first anwsers. |