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

Resolved connect to sql server 2019 Error

  1. Issue
0
Votes
Undo
  1. Allen Ai
    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)

Is there a way to determine "bitness" at runtime?
PowerBuilder 2019 Build 2082 application is not wo...
Responses (4)
Chris Pollach @Appeon
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
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
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
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.