This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 15%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELJ%3C/text%3E%3C/svg%3E)
The C# code throws this error for this connection string: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=W:\SAP_POPfcst_2022-02-16.mdb
However, I setup the same connection using the wizard and the test connection is fine.
Any thoughts why the wizard find the provider but code does not?
Regards,
Lance
@Lance James , Welcome to Microsoft Q&A, I have met this error ever, Please try to change platform to X64 to check if you still have the problem.
Thanks for the 2 responses.
The backslash shouldn’t be the issue. I had also used @ verbatim string literal in front of the string and the same error occurred with single back slash.
I am on X64. SSMS is using 12.0 for the connection string and it works. I was not asked to use 16.0. I tried using 16.0 in the code but that wasn’t liked either.
I will keep searching.
Regards,
Lance
@Lance James , therefore, your current problem is that you need to use Microsoft.ACE.OLEDB.16.0, is right? And you can connect to the database by using x64 for 12.0 without the error you mentioned. If I have some misunderstanding, Please feel free to let me know.
I am on X64 [...]
Does this mean that you removed the "Prefer 32-bit" option from Project Properties?
Thanks JackJJun and Viorel-1 for your assistance.
I am using VS2022 which is 64bit. However, I was only seeing Microsoft.ACE.OLEDB.12.0 as an option (ignore Jet.4.0). I took your comments on 64 bit and found this.
https://learn.microsoft.com/en-us/visualstudio/data-tools/add-new-connections?view=vs-2022
I will try this and give report.
Regards,
Lance
Update:
64X engine is already installed.
I reconfirmed by trying to install
Image is no longer available.
When doing so I receive
Image is no longer available.
In VS, I have a successful connection to the Access DB via the Data Connections Wizard
Image is no longer available.
Image is no longer available.
The Connection String listed in the Database Connection is
Image is no longer available.
The Line in C# code is
string conn = @"Provider=Microsoft.ACE.OLEDB.16.0;Data Source=\axiomfs01\axiom\customerinventorydata\sap_popfcst_2022-02-16.mdb
Frustrating as VS can make the connection fine via the Connection Wizard but I can't via code. Obviously, I must still be missing a piece of the puzzle.
Perhaps, I am not getting this piece referenced in the C# code
Image is no longer available.
Here are the references
Image is no longer available.
Best Regards and thanks everyone for your assistance,
Lance
Additionally, here is my system
Image is no longer available.
Turning over every stone in search of the solution.
Regards,
Lance
Found some info on the Configuration Manager. I change from AnyCPU to x64.
Image is no longer available.
This resolved the error of the 16.0 not registered. A victory, sort of.
As a result of this change to configuration, when I build and debug, I now get this
Image is no longer available.
In the Configuration Manager, I only see options to change the AnyCPU settings for Debug and Release.
Anyone hit this snag?
Regards,
Lance
I am going to call this cake baked.
I searched Just my Code in VS and unchecked the option. Not sure if this is a good thing or not. What I do know is my connection string now works and I am not presented a Just my Code warning modal. If anyone has a reason that disabling this option is bad, please share.
I hope anyone else with the Subject issue can use this thread for resolution.
Image is no longer available.
Regards,
Lance
In the Project Tab, Properties, this window opens. Deselect Prefer 32-bit and set Platform target = x64. Early in this thread JackJJun-MSFT suggested setting the platform to X64 but did not elaborate on how to do what he suggested. This is the solution. Thanks Jack. I found it.
Good luck all,
Lance
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)