• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • 请问下，我用pb2019里面的oracle 11g l连接 oracle 12c 数据库连接不上

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (5)

Resolved 请问下，我用pb2019里面的oracle 11g l连接 oracle 12c 数据库连接不上

  1. How-to
0
Votes
Undo
  1. ? ?
    ? ?
  2. PowerBuilder
  3. Tuesday, 25 October 2022 13:05 PM UTC

我按上面参数方式连接oracle 10g 数据库可以, 但连接oracle 12c 数据库 就提示上面错误，什么原因，怎样处理，谢谢

related pb12.5 install (new pc)
PB2021 - Webbrowser control not working
Responses (5)
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Tuesday, 25 October 2022 13:29 PM UTC
  2. PowerBuilder
  3. # 1

尝试使用“ORA”数据库驱动程序而不是“O10”数据库驱动程序。 以下 URL 指出应该使用 ORA 驱动程序连接到 Oracle 11 及更高版本。

   https://docs.appeon.com/pb2019r3/connecting_to_your_database/Using_Oracle.html#XREF_11471_Supported_versions

[Try using the "ORA" database driver instead of the "O10" database driver. The following URL states that the ORA driver should be used to connect to Oracle 11 and higher.]

SQLCA.DBMS = "ORA"

Comment
There are no comments made yet.
Andreas Mykonios
Andreas Mykonios Accepted Answer Pending Moderation
  1. Tuesday, 25 October 2022 13:30 PM UTC
  2. PowerBuilder
  3. # 2

在帮助文件中提到您应该使用ORA Oracle（对于11g及更高版本）

(Google translated)...

Comment
There are no comments made yet.
? ?
? ? Accepted Answer Pending Moderation
  1. Wednesday, 26 October 2022 00:19 AM UTC
  2. PowerBuilder
  3. # 3

我用这个也不行，我安装了 oracle 12c  64位客户端了，但上面连接还报错，什么原因，谢谢

Comment
There are no comments made yet.
Peter Pang @Appeon
Peter Pang @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 26 October 2022 01:55 AM UTC
  2. PowerBuilder
  3. # 4

你好，

原因：

PB IDE是32位应用，只能识别32位的Oracle驱动。

 

解决方案：

请安装32位的Oracle 12C驱动，并检查监听配置，试下是否能解决。

Comment
There are no comments made yet.
? ?
? ? Accepted Answer Pending Moderation
  1. Tuesday, 1 November 2022 06:17 AM UTC
  2. PowerBuilder
  3. # 5

你好，我现在用ora  数据库连接设置可以连接成功，如下：

但我再powerserver 里面建立oracle连接时候就报错，为什么，我服务器已经安装了32位的oracle 12c 客户端了

Comment
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Tuesday, 1 November 2022 06:55 AM UTC
Does your server has a 64 bit oracle client installed? Because that's probably what it's trying to use. (unless you modified some ini file when you installed powerserver to use 32 bit, the server needs 64 bit).

(You can have both 32 and 64 bit clients installed on the server).
  1. Helpful
Kai Zhao @Appeon
  1. Kai Zhao @Appeon
  2. Tuesday, 1 November 2022 07:35 AM UTC
看截图你使用的是PowerServer 2020或之前的版本，Toolkit中的这个配置界面实际配置的PowerServer中的data source，与AEM > Server > Resources > Data Source中配置相同，建议你到AEM中试试看具体什么错误，然后提供错误信息给我们分析。

请注意32-bit PowerServer需要32-bit Oracle client，64-bit PowerServer需要64-bit Oracle client，如果遇到"oracle 9i failed: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater"错误，请参考下面问斩解决，

https://docs.appeon.com/ps2020/appeon_troubleshooting_guide/oracle_9i_failed_system.html
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.