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

Resolved pb2019用什么方式连接mysql

  1. How-to
0
Votes
Undo
  1. ? ?
    ? ?
  2. PowerBuilder
  3. Thursday, 5 May 2022 13:07 PM UTC

是不是pb2019没有专门的数据库接口连接mysql ,  如果用比如odbc 或 ado 或 jdbc  等方式连接mysql ，用哪种连接更稳定，性能更好? 怎样连接？

谢谢

How to use PFC Resize?
Run AutoBuild2021 MCVCR100.dll ERROR
Responses (3)
Ken Guo @Appeon
Ken Guo @Appeon Accepted Answer Pending Moderation
  1. Friday, 6 May 2022 06:48 AM UTC
  2. PowerBuilder
  3. # 1

您好，

我们建议你使用ODBC的方式连接MYSQL数据库，你需要先安装MYSQL Connector ODBC Package，然后就可以通过Windows ODBC Data Source连接你的数据库了。

另外，我不建议你使用JDBC，因为PB 2022已经移除对Java的支持，PB 2022将不再支持JDBC。

 

Regards

Ken

 

Comment
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Friday, 6 May 2022 07:14 AM UTC
Hi Ken,

That's crazy!

The previous company that I worked for won't be able to upgrade to PB2022. Most of their customers depend on a JDBC connection.

They'll probably stop using Powerbuilder alltogether.

regards.
  1. Helpful
Ken Guo @Appeon
  1. Ken Guo @Appeon
  2. Monday, 9 May 2022 07:42 AM UTC
Hi Miguel,



Due to an assortment of reasons, PB 2022 no longer supports Java, including JDBC. Please see the following link for details:

https://www.appeon.com/developers/obsolete-and-discontinued-features-in-powerbuilder-2022.html



Regards,

Ken

  1. Helpful
There are no comments made yet.
? ?
? ? Accepted Answer Pending Moderation
  1. Sunday, 8 May 2022 01:31 AM UTC
  2. PowerBuilder
  3. # 2

你好: 我试了下，电脑安装好odbc驱动后，电脑上可以用，但手机端不行，提示连接出错， 是不是配置信息有问题，是不是要数据库ip地址，如果要添加哪里？

//SQLCAaa=create Transaction;
//SQLCAaa.DBMS = "ODBC"
//SQLCAaa.AutoCommit = False
//SQLCAaa.DBParm = "ConnectString='DSN=mysql;UID=root;PWD=111'"
//If SQLCAaa.SQLCODE <> 0 Then
// MessageBox (""," 网络数据库连接出错-mysql库! ")
// Halt Close
// Return
//
//End If
//

Comment
Ken Guo @Appeon
  1. Ken Guo @Appeon
  2. Monday, 9 May 2022 05:18 AM UTC
您好，你说手机端不行，你是指PowerServer 2020 or Older 的产品吗？如果你要使用PowerServer 2020 or Older连接MySQL，建议使用Native Driver，具体请参见：

https://docs.appeon.com/2017/server_configuration_guide_for_net/connection_cache_settings_for_mysql_native_driver.html
  1. Helpful
There are no comments made yet.
? ?
? ? Accepted Answer Pending Moderation
  1. Sunday, 8 May 2022 02:22 AM UTC
  2. PowerBuilder
  3. # 3

电脑上用这个的可以连接，但我电脑上 进行应用执行：报连接错误

 

 

 

Comment
Ken Guo @Appeon
  1. Ken Guo @Appeon
  2. Monday, 9 May 2022 05:15 AM UTC
你好，你PB代码执行失败的原因是你没有写下面这句代码：

connect using sqlca;

  1. Helpful 1
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.