访问Oracle数据库的正面接口 [英] Access frontal interface for Oracle database
问题描述
各位大家好，
有人能给我一些关于如何为Oracle数据库开发
Access界面的指示吗？
我在Windows XP Pro 5.1.2600 SP2 Nu上处理Access 2003（11.6566.8107）SP2，Oracle 9i 9.2.0.1.0和
ODBC 3.525.1117.0 2600.
我从Access执行Oracle存储过程失败，并且从SQL * Plus激活了一个用于将数据存储到临时表的触发器b $ b，但是
不是来自Access。
所以，我的访问基础可以连接一个用户，而不是一百个请求。
任何人？
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 ?
推荐答案
" Gloops" < gl **** @ invalid.zailes.orgwrote in message
news：g7 ********** @ aioe.org ...
"Gloops" <gl****@invalid.zailes.orgwrote in message
news:g7**********@aioe.org...
大家好，
是否有人能够给我一些关于如何为Oracle开发Access
界面的指示数据库？
3.525.1117.0 Pro 5.1.2600 SP2 Nu 2600.
我从Access执行Oracle存储过程失败，并且将数据存储到临时表的触发器
处于活动状态来自SQL * Plus，但不是来自
访问。
因此，我的访问基础可以连接一个用户，而不是一百个请求。
有人吗？
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 ?
不要使用临时表。 Oracle！= MS Sql Server
您可能必须使用传递查询来执行存储过程。
Don''t use temporary tables. Oracle!=MS Sql Server
You would probably have to use a pass through query to do a stored proc.
gym dot scuba dot kennedy在gmailaécrit，le 10/08/2008 03:15：
gym dot scuba dot kennedy at gmail a écrit, le 10/08/2008 03:15 :
>我无法从Access执行Oracle存储过程
>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 ?
" ; Gloops" < gl **** @ invalid.zailes.orgwrote in message
news：g7 ********** @ aioe.org ...
gym dot scuba dot kennedy at gmailaécrit，le 10/08/2008 03:15：
"Gloops" <gl****@invalid.zailes.orgwrote in message
news:g7**********@aioe.org...
gym dot scuba dot kennedy at gmail a écrit, le 10/08/2008 03:15 :
>我执行失败Access
中的Oracle存储过程
>I failed executing an Oracle stored procedure from Access
您可能必须使用传递查询来执行存储过程。
You would probably have to use a pass through query to do a stored proc.
嗯，你介意给出一些细节吗？
多年来我没有用过访问权限。这是我最好的猜测。您是否在搜索类似于您要尝试的示例的某个示例？
Jim
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
这篇关于访问Oracle数据库的正面接口的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
