从Oracle UNIX服务器访问MS访问数据库中的数据 [英] Accessing data from an MS access db from an Oracle UNIX server
问题描述
你好，
我是Oracle数据库的新手....
我们有一个可视化前端工具连接到Tru64 UNIX服务器上的Oracle后端
数据库。我们还有MS访问客户的数据库b / b
数据库谁愿意使用这种可视化工具分享他们的数据
工具但不想将他们的数据导入Oracle服务器
后端。
我们有什么方法可以使用Oracle后端来查询MS
Access数据库并将这些数据与Oracle
后端的其他数据可供可视化工具使用？也许通过
ODBC或其他一些标准？
Oracle后端是运行Oracle 8i的Tru64 UNIX服务器。
任何输入都将不胜感激。
Andrea Segovia
A /项目经理
Hello,
I am a newbie to Oracle databases....
We have a visualization front-end tool connected to an Oracle back-end
database on a Tru64 UNIX server. We also have clients with MS access
databases who would like to share their data using this visualization
tool but do not want to import their data into the Oracle server
back-end.
Is there any way we could use the Oracle backend to query the MS
Access databases and merge this data with other data in the Oracle
back-end for presentation by the visualization tool? Perhaps through
ODBC or some other standard?
The Oracle back-end is a a Tru64 UNIX server running Oracle 8i.
Any input would be appreciated.
Andrea Segovia
A/Project Manager
推荐答案
Andrea M. Segovia写道：
Andrea M. Segovia wrote:
您好，
我是Oracle数据库的新手......
我们有一个可视化前端工具，连接到Tru64 UNIX服务器上的Oracle后端数据库。我们还拥有MS访问数据库的客户，他们希望使用这种可视化工具共享他们的数据，但又不想将他们的数据导入到Oracle服务器的后端。
我们有什么办法可以使用Oracle后端查询MS
Access数据库，并将这些数据与Oracle后端的其他数据合并，以便可视化工具进行演示？也许通过ODBC或其他一些标准？
Oracle后端是运行Oracle 8i的Tru64 UNIX服务器。
任何输入都将受到赞赏。 />
Andrea Segovia
A /项目经理
Hello,
I am a newbie to Oracle databases....
We have a visualization front-end tool connected to an Oracle back-end
database on a Tru64 UNIX server. We also have clients with MS access
databases who would like to share their data using this visualization
tool but do not want to import their data into the Oracle server
back-end.
Is there any way we could use the Oracle backend to query the MS
Access databases and merge this data with other data in the Oracle
back-end for presentation by the visualization tool? Perhaps through
ODBC or some other standard?
The Oracle back-end is a a Tru64 UNIX server running Oracle 8i.
Any input would be appreciated.
Andrea Segovia
A/Project Manager
Oracles异构服务应该做你需要的，你设置一个
dblink to Access" database"通过ODBC然后或多或少对待它
像任何其他链接数据库一样。
Oracles Heterogeneous services should do what you need, you set up a
dblink to the Access "database" thru ODBC and then more or less treat it
like any other linked db.
Andrea M. Segovia写道：
Andrea M. Segovia wrote:
您好，
我是Oracle数据库的新手....
我们有一个连接到Oracle后端的可视化前端工具
Tru64 UNIX服务器上的数据库。我们还拥有MS访问数据库的客户，他们希望使用这种可视化工具共享他们的数据，但又不想将他们的数据导入到Oracle服务器的后端。
我们有什么办法可以使用Oracle后端查询MS
Access数据库，并将这些数据与Oracle后端的其他数据合并，以便可视化工具进行演示？也许通过ODBC或其他一些标准？
Oracle后端是运行Oracle 8i的Tru64 UNIX服务器。
任何输入都将受到赞赏。 />
Andrea Segovia
A /项目经理
Hello,
I am a newbie to Oracle databases....
We have a visualization front-end tool connected to an Oracle back-end
database on a Tru64 UNIX server. We also have clients with MS access
databases who would like to share their data using this visualization
tool but do not want to import their data into the Oracle server
back-end.
Is there any way we could use the Oracle backend to query the MS
Access databases and merge this data with other data in the Oracle
back-end for presentation by the visualization tool? Perhaps through
ODBC or some other standard?
The Oracle back-end is a a Tru64 UNIX server running Oracle 8i.
Any input would be appreciated.
Andrea Segovia
A/Project Manager
您的管理层需要停止与拥有MS的人玩游戏
访问数据库并将所有数据放入Oracle。
如果你没有Oracle ......那么你使用MS Access。但是，一旦你有了b $ b，那么就没有任何借口可以将商业数据放在PC上，而这些数据没有安全性，也没有数据完整性的保证，而且几乎没有任何保障。 b $ b无疑是没有夜间备份。
甲骨文所有的钱，他们让一些抱怨者做出商业决策。管理......需要管理。
移动数据......
-
Daniel Morgan
http：//www.outreach.washington。 edu / e ... ad / oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
da ****** @ x.washington.edu
（将''x''替换为''u''来回复）
Your management needs to stop playing games with those that have the MS
Access databases and put all of the data into Oracle.
If you didn''t have Oracle ... fine so you use MS Access. But once you
have Oracle there is no excuse for business data sitting on PCs where
there is no security, no guarantee of data integrity, and almost
undoubtedly no nightly backup.
All that money for Oracle and they are letting a some whiners make the
business decisions. Management ... needs to manage.
Move the d... data.
--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
da******@x.washington.edu
(replace ''x'' with a ''u'' to reply)
Daniel Morgan写道：
Daniel Morgan wrote:
Andrea M. Segovia写道：
Andrea M. Segovia wrote:
您好，
我是Oracle数据库的新手....
我们有一个连接到Oracle后端的可视化前端工具 Tru64 UNIX服务器上的数据库。我们还拥有MS访问数据库的客户，他们希望使用这种可视化工具共享他们的数据，但又不想将他们的数据导入到Oracle服务器的后端。
我们有什么办法可以使用Oracle后端查询MS
Access数据库，并将这些数据与Oracle后端的其他数据合并，以便可视化工具进行演示？也许通过ODBC或其他一些标准？
Oracle后端是运行Oracle 8i的Tru64 UNIX服务器。
任何输入都将受到赞赏。
Andrea Segovia
A /项目经理
Hello,
I am a newbie to Oracle databases....
We have a visualization front-end tool connected to an Oracle back-end
database on a Tru64 UNIX server. We also have clients with MS access
databases who would like to share their data using this visualization
tool but do not want to import their data into the Oracle server
back-end.
Is there any way we could use the Oracle backend to query the MS
Access databases and merge this data with other data in the Oracle
back-end for presentation by the visualization tool? Perhaps through
ODBC or some other standard?
The Oracle back-end is a a Tru64 UNIX server running Oracle 8i.
Any input would be appreciated.
Andrea Segovia
A/Project Manager
您的管理层需要停止与拥有MS访问数据库的人一起玩游戏并将所有数据放入Oracle。
如果您没有Oracle ......那么您使用MS Access。但是，一旦你拥有了Oracle，就没有理由将商业数据放在PC上，这些数据没有安全性，无法保证数据的完整性，而且几乎无需夜间备份。
为Oracle提供所有这些钱，他们让一些抱怨者做出商业决策。管理......需要管理。
移动d ...数据。
Your management needs to stop playing games with those that have the MS
Access databases and put all of the data into Oracle.
If you didn''t have Oracle ... fine so you use MS Access. But once you
have Oracle there is no excuse for business data sitting on PCs where
there is no security, no guarantee of data integrity, and almost
undoubtedly no nightly backup.
All that money for Oracle and they are letting a some whiners make the
business decisions. Management ... needs to manage.
Move the d... data.
我同意这是丹尼尔最好的解决方案，但是在某些情况下（比如
mine），它可能不实用甚至可行。我们的许多地区都在购买这些小型MSaccess后端niche。只做一件事的程序
当你问他们是否有一个Oracle或SQL服务器版本时，供应商的眼睛开始茫然。我可以咆哮我想要的所有缺点
安全性，没有恢复到失败点等等。但最终
业务部门将购买适合他们需求的东西最好的，我必须
处理它。
Fortunatly我在MsAccess中只有一套桌子，我必须有一个桌子可以从
访问一个基于Oracle的应用程序，但一旦设置好，就会非常好地运行
。我还能早点将这些表格放在他们自己的小型Oracle模式中，但如果产品不支持它，那么我就可以使用
来完成。 ..
I agree thats the best solution overall Daniel, but in some cases (like
mine) it may not be practical or even doable. Many of our areas purchase
these little MSaccess back end "niche" programs that do only one thing
and the vendor''s eyes start to glaze over when you ask them if they have
an Oracle or SQL server version. I can rant all I want about the lack of
security, no restore to point of failure etc.. but in the end the
business unit will purchase what fits their needs best and I have to
deal with it.
Fortunatly I only have one set of tables in MsAccess that I have to have
accesible from an Oracle based app, but once it was set up it runs along
quite nicely. I''d still sooner have the tables sitting in their own
little Oracle schema, but if the product doesn''t support it then I have
to make do...
这篇关于从Oracle UNIX服务器访问MS访问数据库中的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
