How realiably is using ODBC for database access?

Question

1.00/5 (1 vote)

See more:

How must an application to accesses database using odbc be deployed if the end user does even know the meaninv and essence of odbc not to talk of turning it ON on its pc.

Is there a way to ensure that odbc is turned ON for or by the application. I have MS Access in mind if you must know.

Posted 2-Feb-14 13:14pm

Gbenbam

Add a Solution

Comments

PIEBALDconsult 2-Feb-14 19:47pm

"I have MS Access in mind"

Get it out of your mind. Consider SQL Server CE. And why use ODBC when ADO.net with OleDb will do Access?

chaau 2-Feb-14 19:56pm

Just wondering how you turn ODBC on and off? I have not seen such an option before

PIEBALDconsult 2-Feb-14 20:18pm

Probably means "configure" -- create a DSN.

Gbenbam 2-Feb-14 23:46pm

The app I am developing is an app which by virture of its nature will not cost much.The target user are not even supposed to know that it has a database.All they need to know is that it requires MS Access to be installed.It is a desktop app ( not meant for a network).Also , its users are not expected) to have high levek of computer competency.They are supposed to just install and start using it.I haven't developed a desktop app that uses a database in the past so I am considering a data provider that will not require any form of configuring on the part of the user.I hope this additional light that I have shed will be useful.

Gbenbam 2-Feb-14 23:50pm

Ok.I have decided to use OLE provider.Do you think it will meet the stated requirement?

Richard MacCutchan 3-Feb-14 4:33am

Have you considered SQL Compact Edition, as it runs completely on the user's system and does not require any external products to be installed?

Gbenbam 3-Feb-14 7:56am

Does it comes in-built in windows?hat provider does it use? I thought of using Access because every dick and harry in the target market has it installed.A suitable alternative must be such that it comes in-built in windows.

Richard MacCutchan 3-Feb-14 8:26am

I'm not sure whather you need to install it or not, check http://www.microsoft.com/en-us/sqlserver/editions/2012-editions/compact.aspx. As to everyone having MS Access installed, I am not sure that is something you should assume.

Gbenbam 4-Feb-14 6:10am

Thanks.It doesn't.All the needed dll are deployed with it.

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)