1. Winthor Caingles
  2. PowerBuilder
  3. Tuesday, 6 December 2022 22:49 PM UTC

Good day,

I need help in deployment… Hope you can help me…

 

I am using the  Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL), when I deploy it using powerclient… the databse driver does not installed in the client side… I need to manually installed the msoledsql… I check my database and thr sql driver is checked among the list…

 

any suggestion or comments? Need it badly…

 

thank you in advance…

mike S Accepted Answer Pending Moderation
  1. Wednesday, 7 December 2022 22:06 PM UTC
  2. PowerBuilder
  3. # 1

The old sql server oledb driver gets loaded as part of the windows install.   (Not sure about windows 11.)

so you could simply use that rather than a driver you need to install

Comment
There are no comments made yet.
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 7 December 2022 02:55 AM UTC
  2. PowerBuilder
  3. # 2

It’s tricky to have PowerClient install the DB drivers but theoretically doable.  You would need to package the correct installer in the external files tab.  Then you would need to write an install.bat yourself in the preload event of the project object.  You must set it to run as administrator otherwise the driver can’t be installed.  If user doesn’t have admin rights, them even setting the preload to run as administrator will fail.

Comment
There are no comments made yet.
John Fauss Accepted Answer Pending Moderation
  1. Wednesday, 7 December 2022 02:19 AM UTC
  2. PowerBuilder
  3. # 3

Hi, Winthor - 

To add to what Chris has stated, please be aware that MIcrosoft's latest MSOLEDBSQL driver (v19.x) cannot be used with any PowerBuilder version prior to PB 2022. For those earlier versions, you have to use MSOLEDBSQL v18.x.

PB 2022 can use MSOLEDBSQL v18.x or v19.x.

You should also only deploy the MSOLEDBSQL driver using the .msi supplied by Microsoft. There are options for installing it silently:

   https://learn.microsoft.com/en-us/sql/connect/oledb/applications/installing-oledb-driver-for-sql-server?view=sql-server-ver16

Best regards, John

Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 7 December 2022 02:05 AM UTC
  2. PowerBuilder
  3. # 4

Hi Winthrop;

 All the various SQL Server drivers usually come with the DBMS Server installation. You can also install them via the Microsoft website. However, I would advise checking with your DBA Team to make sure that you get the proper client  version that matches the server version.

Regards... Chris 

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.