![]() | |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
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 |
#3
| |||
| |||
|
|
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 |
#4
| |||
| |||
|
|
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 |
#5
| |||
| |||
|
|
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 |
#6
| |||
| |||
|
|
I failed executing an Oracle stored procedure from Access You would probably have to use a pass through query to do a stored proc. |
#7
| |||
| |||
|
|
I failed executing an Oracle stored procedure from Access You would probably have to use a pass through query to do a stored proc. |
#8
| |||
| |||
|
|
I failed executing an Oracle stored procedure from Access You would probably have to use a pass through query to do a stored proc. |
#9
| |||
| |||
|
|
I failed executing an Oracle stored procedure from Access You would probably have to use a pass through query to do a stored proc. |
#10
| |||
| |||
|
|
I failed executing an Oracle stored procedure from Access You would probably have to use a pass through query to do a stored proc. |
![]() |
| Thread Tools | |
| Display Modes | |
| |