Hi Luis;

  FWIW: You cannot just copy the new SS driver across to the client machine. It must be installed via it's corresponding MSI installation file as provided from the Microsoft SQL Server website.

Regards ... Chris

Hi Luis,

Judging from the screenshot you provided, the IACCEPTMSOLEDBSQLLICENSETERMS parameter is missing. Please add it to solve the issue. For example:

msoledbsql.msi /quiet /passive IACCEPTMSOLEDBSQLLICENSETERMS=YES

Regards,
ZhaoKai

Hi Govinda
I following steps of the video but not working, Not install the msoledbsql.msi driver

Thanks
Luis

Hi Luis,

As John mentioned, I did talk about this in the Elevate Keynote demo. But you may find a little more info on the Webinar too https://www.appeon.com/developers/library/videos/powerbuilder-2019-r3-preview-part-4-new-sql-server-driver.html (min 23:06).

You can also find both .msi installers from the official website: https://docs.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver15 

Of course, the examples I showed on the videos are only basic. You would need to create your own scripts and you would want to check if the driver has already been installed on the end user's machine. Otherwise, there's no need to install it again every time the application starts. So you can check the radio button "Only run when the app is launched for the first time or when the app version is updated" in the Project object's "Run options" tab in the "Preload event" section of PowerBuilder 2019 R3. Now, this setting will run the Preload event's script once the app has been downloaded for the first time. But every time you do an update to your application, this event will get triggered again. So you would also want to create your bash script accordingly.

You may find more information about the parameters the .msi installer finds by running this command in your CMD prompt: msoledbsql.msi /? or you may find more documentation about it here: https://docs.microsoft.com/en-us/sql/connect/oledb/applications/installing-oledb-driver-for-sql-server?view=sql-server-ver15

I hope this helps.

Regards,

Greetings, Luis -

Govinda Lopez covered this in his portion of the Elevate keynote session:

https://www.appeon.com/conference/elevate-2020/session-catalog.html

His discussion on this topic begins at approximately 1:34:00 into the replay.

If I recall correctly, Microsoft provides an .msi that can be run silently, so its installation should not be dependent on PowerClient. And since this is a MS product, it is independent of PB 2019 R3.

That being said, please keep in mind that PB 2019 R3 has not yet been released for production use. IMHO, it would not be wise to install beta-release software into a production environment.

Regards, John