1. Allen Ai
  2. PowerBuilder
  3. Friday, 29 July 2022 06:16 AM UTC

Hi:

I finished my application then deployed OK,the execution file could run normally at my computer,but will display message "Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) is not installed" when it started at other computers,would you can give me some solutions(about DB,I used SQL Server 2019),Thanks

PS. I alredy installed  MSOLEDBSQL into other computers that prepare to run my application

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

powerbuilder script as following:

SQLCA.DBMS = "MSOLEDBSQL SQL Server"
SQLCA.LogPass = "Login@22907106!qaz"
SQLCA.ServerName = "192.168.1.62"
SQLCA.LogId = "sa"
SQLCA.AutoCommit = False
SQLCA.DBParm = "Database='CKPLAS'"
connect;
if sqlca.sqlcode <> 0 then
MessageBox ("Sorry! Cannot Connect To Database", sqlca.sqlerrtext)
halt close
return
end if
open(w_main)

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 29 July 2022 08:49 AM UTC
  2. PowerBuilder
  3. # 1

Hi Allen;

   Also, you'll need to deploy the "PBMSO.dll'" PB runtime DB Interface module to communicate to the actual SS db client driver. Make sure that you also grab the correct bitness of these drivers as well that matches the bitness of your App EXE.

HTH

Regards ... Chris 

Comment
There are no comments made yet.
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Friday, 29 July 2022 15:50 PM UTC
  2. PowerBuilder
  3. # 2

Did you install correct version of MSOLEDBSQL on the other machines?  With PB 2019 R3 and 2021, you must use version 18.x of the driver.  PB 2022 supports version 19.x of the driver.

Comment
There are no comments made yet.
Allen Ai Accepted Answer Pending Moderation
  1. Saturday, 30 July 2022 16:04 PM UTC
  2. PowerBuilder
  3. # 3

Thanks for your help,I will check and try on next Monday.

Good luck.

Comment
There are no comments made yet.
Allen Ai Accepted Answer Pending Moderation
  1. Monday, 1 August 2022 05:24 AM UTC
  2. PowerBuilder
  3. # 4

After I install MSOLEDBSQL 1.8 at users' computer,my application can run normally at those machines.It's very inspirable to me.Thank for your help a lots. 

Comment
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.