本文介绍了Coldfusion 9.0.1标准64位和Oracle 11g 64位ODBC连接导致“体系结构不匹配".的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我有一个新构建的64位Windows Server 2008 R2盒,上面安装了64位Coldfusion 9 Standard.我已经将其升级并修复为最新版本的CF.我还在盒子上安装了64位Oracle 11g(11.1.0.7.0)客户端.我已经在Windows中使用64位ODBC数据源管理器创建了系统DSN,并且可以成功测试数据源的连接.

I have a freshly built 64-bit Windows Server 2008 R2 box that I have installed 64-bit Coldfusion 9 Standard on. I've upgraded and hotfixed it up to the most current version of CF. I also had 64-bit Oracle 11g (11.1.0.7.0) Client installed on the box. I've created a System DSN using the 64-bit ODBC Data Source Administrator in Windows and can successfully test the connection of the data source.

所有这些安装都进行得很顺利,但是,当我在Coldfusion Administrator中添加数据源时,收到错误消息:

All of these installations went smoothly, however, when I went to add a datasource in the Coldfusion Administrator I receive the error:

java.sql.SQLException:[Macromedia] [SequeLink JDBC驱动程序] [ODBC套接字]内部错误:指定的DSN包含驱动程序和应用程序之间的体系结构不匹配 根本原因是:java.sql.SQLException:[Macromedia] [SequeLink JDBC驱动程序] [ODBC套接字]内部错误:指定的DSN包含驱动程序和应用程序之间的体系结构不匹配

java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: The specified DSN contains an architecture mismatch between the Driver and Application The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: The specified DSN contains an architecture mismatch between the Driver and Application

由于此盒完全是64位的,所以我很难理解这种体系结构不匹配的根源.在查看所有正在运行的进程时,我看到一些相关的CF进程正在以32位运行(与Verity相关的进程,SOLR和CFDotNetSVC).我不确定是否会导致此问题,但我不知道要解释的是这种不匹配是由其他原因引起的.

I am having a hard time understanding exactly where this architecture mismatch is coming from since the box is entirely 64-bit. I see while looking at all the processes that are running, some related CF processes are running in 32-bit (Verity related processes, SOLR and CFDotNetSVC). I am not sure if those could cause this issue but I am at a loss to explain were this mismatch would come from otherwise.

有人有什么主意吗?

推荐答案

我相信您需要降级到32位驱动程序,或使用本机JDBC驱动程序成功连接到Oracle.我的建议是走JDBC路线,并通过使用数据源"屏幕上的其他"选择直接通过本机Oracle JDBC驱动程序进行连接.这样,您将获得更好的性能,并通过ColdFusion更好地控制您的连接.

I believe you need to either step down to the 32-bit drivers, or use native JDBC drivers to connect to Oracle successfully. My suggestion would be to go the JDBC route, and connect directly through a native Oracle JDBC driver by using the "other" selection on the Datasource screen. You'll get better performance that way, and have more control over your connection via ColdFusion.

连接到Oracle 信息在ColdFusion Livedocs中.

Connecting to Oracle information in ColdFusion Livedocs.

这篇关于Coldfusion 9.0.1标准64位和Oracle 11g 64位ODBC连接导致“体系结构不匹配".的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-27 17:16
查看更多