• You are here:  
  • Home
  • Q&A
  • Q&A
  • Beta Testing
  • How to install the "Microsoft OLE DB Driver for SQL Server"

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

Resolved How to install the "Microsoft OLE DB Driver for SQL Server"

  1. How-to
0
Votes
Undo
  1. Steen Jakobsen
    Steen Jakobsen
  2. Beta Testing
  3. Wednesday, 7 October 2020 16:16 PM UTC

Hi,

How do I the easiest way install the new "Microsoft OLE DB Driver for SQL Server"

Would it be enough to simply copy the single dll (msoledbsql.dll) into ../system32 (or the 32bit version into SysWOW64 for 32 bit pb apps) ?

This link explains the installation procedure however that requires msi exec etc. Not really easy :-)

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

 

any insight would be nice :-)

 

//Steen

  1. Installation
  2. SQL Server
Beta 2019 R3 - Error deploying Powerclient c/s App...
PowerBuilder 2019 R3 Installer does not work
Responses (2)
Ken Guo @Appeon
Ken Guo @Appeon Accepted Answer Pending Moderation
  1. Thursday, 8 October 2020 11:38 AM UTC
  2. Beta Testing
  3. # 1
Hi Steen，
 
When you install the MSI files of the SQL Server OLE DB Driver, it copies these files to the system directory and writes some registry information. PB will also read these registry information when connecting to the OLE DB Driver.
Therefore, it does not support you to copy files manually. It is recommended to use the method recommended by Microsoft, that is, install the MSI file provided by Microsoft.
 
Regards,
Ken
Comment
Steen Jakobsen
  1. Steen Jakobsen
  2. Monday, 12 October 2020 06:10 AM UTC
Thanks a lot ken :-)
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 7 October 2020 16:33 PM UTC
  2. Beta Testing
  3. # 2

Hi Steen;

  Good question. I install both the 32bit and 64bot drivers (as the Apps need) from their respective MSI for each workstation. I have no idea if the "copy" would work. I have my doubts.

FYI: https://docs.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver15

Maybe others can "chime in" here on their SS DB Client deployment experience.

Regards ... Chris

Comment
Steen Jakobsen
  1. Steen Jakobsen
  2. Thursday, 8 October 2020 04:22 AM UTC
Hi Chris,



as far as I can see there is only 1 file but I dont know if there are some registrations needed.

Appeon: do you have some insights on this ?



Thanks

//Steen
  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Thursday, 8 October 2020 15:00 PM UTC
Copy would not work. Ken has explained that the .MSI install process modifies the registry.

Microsoft OLE DB Driver 18.4.0 32-bit download: https://go.microsoft.com/fwlink/?linkid=2131003

Microsoft OLE DB Driver 18.4.0 64-bit download: https://go.microsoft.com/fwlink/?linkid=2129954
  1. Helpful 1
Steen Jakobsen
  1. Steen Jakobsen
  2. Monday, 12 October 2020 06:10 AM UTC
Thanks a lot :-)
  1. Helpful
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.