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

Resolved ADO.net connect

0
Votes
Undo
  1. Chang chihyuan
    Chang chihyuan
  2. PowerBuilder
  3. Friday, 25 March 2022 01:12 AM UTC

我的內容如下 :

SQLCA.DBMS = "ADO.Net"
SQLCA.LogId = "xxxx"
SQLCA.LogPass = "xxxxxxxx"
SQLCA.AutoCommit = False
sqlca.dbparm = "Namespace='System.Data.SqlClient',DataSource='192.168.20.3',Database='saphana'"
connect using sqlca;
return sqlca.sqlcode


在開發環境 return 的數值是 0 ，但是在使用者環境是 -1(有裝Packages) ，除非我在使用者電腦安裝 powerbuilder IDE 程式，就可以return 的數值是 0 ，就算我把裝 powerbuilder IDE 程式後的目錄都刪掉，也不會影響。

請問是使用者端是缺了甚麼 ?

  1. PowerBuilder
How to PostData using HTTPClient and how to read t...
Application is Crashing When MModal is installed i...
Accepted Answer
Ken Guo @Appeon
Ken Guo @Appeon Accepted Answer Pending Moderation
  1. Friday, 25 March 2022 07:01 AM UTC
  2. PowerBuilder
  3. # Permalink

Hi Chang,

請將開發環境中的這個.\Program Files (x86)\Appeon\PowerBuilder ##.0\DotNET\bin\Sybase.PowerBuilder.DataSource.Sharing.dll 文件複製到你的應用程序EXE所在的目錄中，然後重試看是否還有問題。

在PB 2022版本中，我們會改進ado.net這方面的文檔說明。

 

Regards,

Ken

Comment
Chang chihyuan
  1. Chang chihyuan
  2. Friday, 25 March 2022 08:58 AM UTC
還是不行耶，不過我把所有\Program Files (x86)\Appeon\PowerBuilder ##.0\DotNET\bin\ 下的DLL檔 ，都複製到應用程序EXE所在的目錄中， 就可以了，不知道是哪幾個是必須的?
  1. Helpful
Ken Guo @Appeon
  1. Ken Guo @Appeon
  2. Friday, 25 March 2022 09:33 AM UTC
你驗證一下將這兩個文件（Sybase.PowerBuilder.Db.dll，Sybase.PowerBuilder.DbExt.dll ）也複製到exe所在的目錄中。

  1. Helpful
There are no comments made yet.
Responses (1)


There are replies in this question but you are not allowed to view the replies from this question.