使用Oracle Client 11部署.Net应用程序 [英] Deploy a .Net application with Oracle Client 11

问题描述

我已经

I've followed this post and it's not working. Can someone tell me what else to check?

我遵循的步骤:

1. 我将当前安装的Oracle(11gR2_x32)中的dll添加到了项目的根目录中.我没有按照帖子中的说明使用basic-lite，但我认为dll是相同的，对吗?

1. I added dll's from my current install of Oracle (11gR2_x32) to the root of my project. I did not use the basic-lite as the post stated but I assumed that the dll's would be the same, right?

• oci.dll
• ociw32.dll
• Oracle.DataAccess.DLL
• orannzsbb11.dll
• oraocci11.dll
• oraociicus11.dll
• OraOps11w.dll

选择项目中的每个dll，并将构建操作"设置为内容"，并将复制到输出目录"设置为始终复制"

Selected each dll within my project and set the 'Build Action' to 'Content' and 'Copy to Output Directory' to 'Copy Always'

添加了对Oracle.DataAccess的引用

Added a reference to Oracle.DataAccess

在我的vb代码中添加了导入Oracle.DataAccess.Client".

Added 'Imports Oracle.DataAccess.Client' to my vb code.

代码工作正常，但仍然需要用户安装Oracle.我的意图是不要让他们安装oracle.我验证了他们安装我的程序时，所有dll都存在于程序文件夹中.

The code works fine but it still requires the user to install Oracle. My intent was to not have them install oracle. I verified that when they install my program all the dll's are present in the program folder.

我还能检查什么?

推荐答案

代码工作正常，但仍然需要用户安装Oracle.我的目的是不要让他们安装oracle.

The code works fine but it still requires the user to install Oracle. My intent was to not have them install oracle.

据我所知，没有真正的嵌入式" Oracle，您无法避免安装Oracle数据库服务器.如果您确实需要嵌入式数据库，则有几种不错的选择，包括但不限于:SQLite ，MS SQL Server Compact或LocalDB ¹ ，Interbase/Firebird等...

To my knowledge, there is no truly "embedded" Oracle and you cannot avoid installing the Oracle database server. If you really need an embedded database, there are several good alternatives, including but not limited to: SQLite, MS SQL Server Compact or LocalDB¹, Interbase/Firebird etc...

几年前，Oracle为公司运行了一个许可计划，您可以在其中将Oracle安装程序集成到自己的安装程序中，并使它对用户不可见"，但这仍然会安装完整的Oracle服务器.例如，这就是安装PTC Pro/INTRALINK的早期版本的方式-您不需要单独的Oracle安装.我不知道该许可程序是否仍然可用，但是即使有，您可能也在寻找一笔非常可观的财务投资.

Few years back, Oracle ran a licensing program for companies, where you could integrate the Oracle setup into your own setup and make it "invisible" to users, but this would still install the full Oracle server. That's how earlier versions of PTC Pro/INTRALINK installed for example - you didn't need a separate Oracle installation. I don't know whether this licensing program is still available, but even if it were, you are probably looking at a very significant financial investment.

BTW，用于Oracle的完全托管的.NET提供程序是当前位于beta -这将进一步简化客户端部署，并消除32位与64位不匹配的情况.

BTW, Fully Managed .NET provider for Oracle is currently in beta - this will ease the client deployment even further and eliminate 32-bit vs 64-bit mismatches.

¹ 从技术上讲，LocalDB不像进程内"那样嵌入"，但对最终用户可能没有任何影响.

¹ LocalDB is not technically "embedded" as in "in-process", but that probably won't make a difference to your end users.

这篇关于使用Oracle Client 11部署.Net应用程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！