Can't change DB Provider

This forum can be browsed by the general public. Posting is limited to current SAPIEN license holders with active maintenance and does not offer a response time guarantee.
Forum rules
DO NOT POST LICENSE NUMBERS, ACTIVATION KEYS OR ANY OTHER LICENSING INFORMATION IN THIS FORUM.
Only the original author and our tech personnel can reply to a topic that is created in this forum. If you find a topic that relates to an issue you are having, please create a new topic and reference the other in your post.

Any code longer than three lines should be added as code using the 'Select Code' dropdown menu or attached as a file.
This topic is 4 years and 7 months old and has exceeded the time allowed for comments. Please begin a new topic or use the search feature to find a similar but newer topic.
User avatar
dakotazinn
Posts: 20
Last visit: Wed Mar 31, 2021 7:12 am

Can't change DB Provider

Post by dakotazinn »

To help you better we need some information from you.

*** Please fill in the fields below. If you leave fields empty or specify 'latest' rather than the actual version your answer will be delayed as we will be forced to ask you for this information. ***

Product: PowerShell Studio 2019 (64 Bit)
Build: v5.6.166
OS: Windows 10 Enterprise (64 Bit)
Build: v10.0.17763.0

*** Please add details and screenshots as needed below. ***

When creating an Access DB Connection in the Object Browser, I am unable to change the Provider
The Provider string "Provider=Microsoft.ACE.OLEDB.12.0" works on my machine, but the defaulting provider "Provider=Microsoft.Jet.OLEDB.4.0" 'Is not registered on this machine'
But when I change the provider string to ACE, as soon as I click 'OK', it defaults back to the JET provider

DO NOT POST SUBSCRIPTIONS, KEYS OR ANY OTHER LICENSING INFORMATION IN THIS FORUM
User avatar
brittneyr
Site Admin
Posts: 1655
Last visit: Thu Mar 28, 2024 11:13 am
Answers: 39
Been upvoted: 30 times

Re: Can't change DB Provider

Post by brittneyr »

Thank you for reporting this issue. I was able to reproduce this and have filed an internal bug report. When I have more information to share, I'll post it here.
Brittney
SAPIEN Technologies, Inc.
User avatar
brittneyr
Site Admin
Posts: 1655
Last visit: Thu Mar 28, 2024 11:13 am
Answers: 39
Been upvoted: 30 times

Re: Can't change DB Provider

Post by brittneyr »

For now, you should be able to connect with the OLEDB option, instead of the Access option, by entering your connection string:
SPS-DataConnections.png
SPS-DataConnections.png (17.27 KiB) Viewed 1878 times
Brittney
SAPIEN Technologies, Inc.
User avatar
dakotazinn
Posts: 20
Last visit: Wed Mar 31, 2021 7:12 am

Re: Can't change DB Provider

Post by dakotazinn »

Thank you, brittneyr
This topic is 4 years and 7 months old and has exceeded the time allowed for comments. Please begin a new topic or use the search feature to find a similar but newer topic.