2,596
社区成员
发帖
与我相关
我的任务
分享客户不安装Oracle客户端直接访问Oracle数据库
最近一直在找一种不用在最终客户机上安装Oracle客户端软件，直接访问Oracle数据库的方法。很多朋友都指点我，一般来讲，Oracle最好安装客户端软件。如果不想安装，那么大致有两种方法：
1。使用Midas三层结构，加应用程序服务器。
2。使用第三方控件，例如ODAC NET EDITION（http://www.crlab.com），后面是它的
介绍。
按照我现在参加的项目，第一种不太可能，但是第二种的控件，也不知道是因为只得到试用版的缘故，还是操作不当，仍然不能直接连接，不知道各位有没有用过，指点一下，多谢，多谢。
Advantages of Net option:
ODAC Standard as the most of applications which work with Oracle uses Oracle Call Interface to connect to Oracle database server. This is usual way to develop Oracle application with a third-generation language. As all OCI routines are in external libraries compiled application has small size. But it requires Oracle client software installed on workstation that is the cause of additional expenses for its installation and administration. Sometimes installation of Oracle client can be not advisable or even impossible. For example, if you need to set your application on remote machine where you don't have respective specialist.
ODAC Net allows your application to work with Oracle directly through TCP/IP protocol and doesn't require Oracle client software. To run your application built with ODAC Net it is only needed to have operation system and TCP/IP protocol support.
To connect to Oracle server with ODAC Net you need know the address of computer where Oracle server is, listening port number and database instance name.
1。使用Midas三层结构，加应用程序服务器。
2。使用第三方控件，例如ODAC NET EDITION（http://www.crlab.com），后面是它的
介绍。
按照我现在参加的项目，第一种不太可能，但是第二种的控件，也不知道是因为只得到试用版的缘故，还是操作不当，仍然不能直接连接，不知道各位有没有用过，指点一下，多谢，多谢。
Advantages of Net option:
ODAC Standard as the most of applications which work with Oracle uses Oracle Call Interface to connect to Oracle database server. This is usual way to develop Oracle application with a third-generation language. As all OCI routines are in external libraries compiled application has small size. But it requires Oracle client software installed on workstation that is the cause of additional expenses for its installation and administration. Sometimes installation of Oracle client can be not advisable or even impossible. For example, if you need to set your application on remote machine where you don't have respective specialist.
ODAC Net allows your application to work with Oracle directly through TCP/IP protocol and doesn't require Oracle client software. To run your application built with ODAC Net it is only needed to have operation system and TCP/IP protocol support.
To connect to Oracle server with ODAC Net you need know the address of computer where Oracle server is, listening port number and database instance name.
...全文
请发表友善的回复…
发表回复
guo 2001-08-10
- 打赏
- 举报
它对于 7.3可以但其它版本需要其它的组件
不知道43M的客户你能否忍受? 如果可以,你可以到technet.oracle.com下载一个oledb的驱动,它是一个完整的oracl客户端,如果要使用其它驱动可以再下载其它程序.
不知道43M的客户你能否忍受? 如果可以,你可以到technet.oracle.com下载一个oledb的驱动,它是一个完整的oracl客户端,如果要使用其它驱动可以再下载其它程序.
格利高里 2001-08-10
- 打赏
- 举报
一个pb站点上提供的方法：
不安装Oracle客户连接Oracle 8的方法：
只需要将文件：CORE35.DLL CORE35O.DLL NASNSNT.DLL NAUNTSNT.DLL NCRNT.DLL NInt.dll NLSRTL32.DLL Nnfdnt.dll NNFNNT.DLL NSNT.DLL NTNT.DLL NTTNT.DLL OCIW32.DLL Ora73.dll OTRACE73.DLL sqltnsnt.dll sqlnet.ora tnsnames.ora 拷贝到EXE文件所在目录就行了，是不是很简单啊，不过站长目前暂时无法进行测试，有条件的朋友请帮站长测试一下吧！：） 2001.7.18 新
不安装Oracle客户连接Oracle 8的方法：
只需要将文件：CORE35.DLL CORE35O.DLL NASNSNT.DLL NAUNTSNT.DLL NCRNT.DLL NInt.dll NLSRTL32.DLL Nnfdnt.dll NNFNNT.DLL NSNT.DLL NTNT.DLL NTTNT.DLL OCIW32.DLL Ora73.dll OTRACE73.DLL sqltnsnt.dll sqlnet.ora tnsnames.ora 拷贝到EXE文件所在目录就行了，是不是很简单啊，不过站长目前暂时无法进行测试，有条件的朋友请帮站长测试一下吧！：） 2001.7.18 新
flysnow2000 2001-08-10
- 打赏
- 举报
安装Oracle客户端之后还要进行本地网络服务名配置，如果只拷贝一些DLL或者oledb驱动的话，是不是不用进行设置了呢？
