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

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
  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 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
  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
  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
  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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.