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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.