connection string based on ms access version present in PC

Question

0.00/5 (No votes)

See more:

I have developed a windows application. My development environment is win7, office2007, C#, VS2010, Winforms. My application stores data in MS Access.

Is there any way with which i can create a connection string based on MS Access version present in PC?

Posted 16-Jan-14 3:29am

markand911

Add a Solution

Comments

ZurdoDev 16-Jan-14 9:59am

Yes, but what do you mean? Have you looked at connectionstrings.com?

markand911 17-Jan-14 1:13am

RyanDev, I mean when i install my application in any windows machine, my application should work smoothly by connection to any version of MS Access. also it should work with any Oledb Driver installed in the PC. How to implement such scenario in C#.net

ZurdoDev 17-Jan-14 7:15am

It sounds like you need to build an option for them to pick an ODBC connection. Or perhaps, you can just change the connection string.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Aarti Meswania · Answer 1 · 2014-01-16T05:31:00

Solution 1

C#

string constr = "Data Source =" + strPath + "\YourDBName.mdb;Provider = Microsoft.Jet.OLEDB.4.0;"

Happy Coding!
:)

Posted 16-Jan-14 5:31am

Aarti Meswania

Comments

markand911 17-Jan-14 1:12am

Thanks Aarti. what i mean is how to decide what data provider i have to use. Whether to use Microsoft.Jet.OLEDB 4.0 or Microsoft.ACE.OLEDB 12.0 or something else. This also depends on which driver is installed in the PC.