Trouble with connecting Access DB

Lance James 371

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

Jack J Jun 24,501 Reputation points Microsoft Vendor

2022-02-17T01:27:56.47+00:00

@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.
Lance James 371 Reputation points

2022-02-17T01:55:43.74+00:00

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
Jack J Jun 24,501 Reputation points Microsoft Vendor

2022-02-17T02:11:14.41+00:00

@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.
Viorel 116.6K Reputation points

2022-02-17T06:41:51.137+00:00

I am on X64 [...]

Does this mean that you removed the "Prefer 32-bit" option from Project Properties?
Lance James 371 Reputation points

2022-02-17T11:57:25.573+00:00

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
Lance James 371 Reputation points

2022-02-17T12:24:08.31+00:00

Update:

64X engine is already installed.

I reconfirmed by trying to install

When doing so I receive

In VS, I have a successful connection to the Access DB via the Data Connections Wizard

The Connection String listed in the Database Connection is

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

Here are the references

Best Regards and thanks everyone for your assistance,
Lance
Lance James 371 Reputation points

2022-02-17T12:45:45.49+00:00

Additionally, here is my system

Turning over every stone in search of the solution.

Regards,
Lance
Lance James 371 Reputation points

2022-02-17T13:18:18.77+00:00

Found some info on the Configuration Manager. I change from AnyCPU to x64.

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

In the Configuration Manager, I only see options to change the AnyCPU settings for Debug and Release.

Anyone hit this snag?

Regards,
Lance
Lance James 371 Reputation points

2022-02-17T13:30:17.477+00:00

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.

Regards,
Lance

2 answers

Anonymous

2022-02-17T00:48:40.017+00:00

The double backslash?
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Lance James 371 Reputation points

2022-02-17T23:20:12.087+00:00

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
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Trouble with connecting Access DB

2 answers

Your answer