windows 连接到 Oracle 8.1.7 - 如何获得正确的 ODBC 驱动程序？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/2075733/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Connecting to Oracle 8.1.7 - how to get the right ODBC driver?
提问by Geoff Maddock
I have a Vista machine that needs to remotely connect to Oracle 8.1.7 database. Installing the instant client with the ODBC pack gets an ODBC driver, but when you create a datasource with it, it says it's no longer compatible with that database version.
我有一台需要远程连接到 Oracle 8.1.7 数据库的 Vista 机器。使用 ODBC 包安装即时客户端会获得一个 ODBC 驱动程序，但是当您使用它创建数据源时，它说它不再与该数据库版本兼容。
What's the best way to get the correct ODBC driver?
获得正确的 ODBC 驱动程序的最佳方法是什么？
采纳答案by TallTed
The Oracle 10g OCI Client and Instant Client can connect to Oracle 8.1.7.4 and later; earlier 8i patchsets mandate a 9i or 8i OCI Client.
Oracle 10g OCI Client 和 Instant Client 可以连接到 Oracle 8.1.7.4 及更高版本；早期的 8i 补丁集要求使用 9i 或 8i OCI 客户端。
The driver hwilliams suggested earlier requires that you have a functional 8i or 9i OCI Client on the Vista host.
之前建议的驱动程序 hwilliams 要求您在 Vista 主机上具有功能强大的 8i 或 9i OCI 客户端。
OpenLink Software(my employer) also has Multi-Tier solutions for 8i and 9i, free to try for 2 weeks, which will support Vista (and many other OS) ODBC (and JDBC and ADO.NET) clients. All you need is an 8i or 9i Client on any host with a supported OS on which you can install the OpenLink server-side components, including the Oracle server host itself, which includes these OCI components as part of the default installation.
OpenLink Software（我的雇主）也有适用于 8i 和 9i 的多层解决方案，可免费试用 2 周，它将支持 Vista（和许多其他操作系统）ODBC（以及 JDBC 和 ADO.NET）客户端。您所需要的只是具有受支持操作系统的任何主机上的 8i 或 9i 客户端，您可以在其上安装 OpenLink 服务器端组件，包括 Oracle 服务器主机本身，其中包含这些 OCI 组件作为默认安装的一部分。
回答by Gary Myers
Firstly, you mean 8.1.7, not 8.7.1.
首先，您的意思是 8.1.7，而不是 8.7.1。
Secondly, I think 10g permitted connections to an 8.1.7 database. Don't even try an 11g client. I think the Instant Clients came out after 8i was desupported, so I wouldn't be surprised if they didn't work.
其次，我认为 10g 允许连接到 8.1.7 数据库。甚至不要尝试 11g 客户端。我认为 Instant Clients 是在 8i 被取消支持后出现的，所以如果它们不起作用我不会感到惊讶。
You could try a 10g full client install but I doubt whether you'd get that working on Vista. Either you need a newer (supported) database version or an older operating system.
您可以尝试安装 10g 完整客户端，但我怀疑您是否可以在 Vista 上使用它。您需要更新的（受支持的）数据库版本或旧的操作系统。
Can you use a JDBC connection ?
您可以使用 JDBC 连接吗？
回答by APC
Do you have a support contract? Because I have just checked on MyOracleSupportand they still offer ODBC patch sets for 8i. Although it might be tough to get them running on Vista. Mind you, I hear it's tough getting anythingrunning on Vista.
你有支持合同吗？因为我刚刚检查了MyOracleSupport，他们仍然为 8i 提供 ODBC 补丁集。尽管让它们在 Vista 上运行可能很困难。请注意，我听说在 Vista 上运行任何东西都很难。
Alternatively, are you prepared to spend money on this? If so, then DataDirect claims their Oracle ODBC driver can connect to all versions, from 8i through to 11g. They offer a free trial. Check it out.
或者，您准备好为此花钱吗？如果是这样，那么 DataDirect 声称他们的 Oracle ODBC 驱动程序可以连接到从 8i 到 11g 的所有版本。他们提供免费试用。 一探究竟。
回答by AABBCCDD
Oracle 8? That is more than 10 years old. Isn't it time to switch to Oracle 11? After upgrading to Oracle 11, you can certainly find an odbc driver.
甲骨文8？那是10多岁了。是不是该切换到 Oracle 11 了？升级到 Oracle 11 后，当然可以找到 odbc 驱动程序。
