dbTalk Databases Forums  

Access frontal interface for Oracle database

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss Access frontal interface for Oracle database in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Gloops
 
Posts: n/a

Default Access frontal interface for Oracle database - 08-09-2008 , 04:53 PM






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 ?

Reply With Quote
  #2  
Old   
gym dot scuba dot kennedy at gmail
 
Posts: n/a

Default Re: Access frontal interface for Oracle database - 08-09-2008 , 08:15 PM







"Gloops" <gloops (AT) invalid (DOT) zailes.org> wrote

Quote:
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.




Reply With Quote
  #3  
Old   
gym dot scuba dot kennedy at gmail
 
Posts: n/a

Default Re: Access frontal interface for Oracle database - 08-09-2008 , 08:15 PM




"Gloops" <gloops (AT) invalid (DOT) zailes.org> wrote

Quote:
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.




Reply With Quote
  #4  
Old   
gym dot scuba dot kennedy at gmail
 
Posts: n/a

Default Re: Access frontal interface for Oracle database - 08-09-2008 , 08:15 PM




"Gloops" <gloops (AT) invalid (DOT) zailes.org> wrote

Quote:
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.




Reply With Quote
  #5  
Old   
gym dot scuba dot kennedy at gmail
 
Posts: n/a

Default Re: Access frontal interface for Oracle database - 08-09-2008 , 08:15 PM




"Gloops" <gloops (AT) invalid (DOT) zailes.org> wrote

Quote:
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.




Reply With Quote
  #6  
Old   
Gloops
 
Posts: n/a

Default Re: Access frontal interface for Oracle database - 08-10-2008 , 03:57 AM



gym dot scuba dot kennedy at gmail a écrit, le 10/08/2008 03:15 :
Quote:
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 ?




Reply With Quote
  #7  
Old   
Gloops
 
Posts: n/a

Default Re: Access frontal interface for Oracle database - 08-10-2008 , 03:57 AM



gym dot scuba dot kennedy at gmail a écrit, le 10/08/2008 03:15 :
Quote:
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 ?




Reply With Quote
  #8  
Old   
Gloops
 
Posts: n/a

Default Re: Access frontal interface for Oracle database - 08-10-2008 , 03:57 AM



gym dot scuba dot kennedy at gmail a écrit, le 10/08/2008 03:15 :
Quote:
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 ?




Reply With Quote
  #9  
Old   
Gloops
 
Posts: n/a

Default Re: Access frontal interface for Oracle database - 08-10-2008 , 03:57 AM



gym dot scuba dot kennedy at gmail a écrit, le 10/08/2008 03:15 :
Quote:
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 ?




Reply With Quote
  #10  
Old   
gym dot scuba dot kennedy at gmail
 
Posts: n/a

Default Re: Access frontal interface for Oracle database - 08-10-2008 , 08:34 AM




"Gloops" <gloops (AT) invalid (DOT) zailes.org> wrote

gym dot scuba dot kennedy at gmail a écrit, le 10/08/2008 03:15 :
Quote:
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





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.