ODBC connection in vb.net through Code

Question

1.00/5 (1 vote)

See more:

I use ODBC data source to connect vb.net application to MS ACCESS database.When I have to install it in my clients PC,I have to manually make ODBC connection
from(Control Panel ->Administrative Tools->Data source(ODBC)).
Now what I want to do is,include odbc connection string in vb.net code itself so that I dont have to manually create odbc connection in clients PC.Is it possible to do so??
If no,then is there any other alternative?
Thanks in advance.

Posted 16-Dec-12 17:40pm

Rachna0309

Add a Solution

Comments

Sergey Alexandrovich Kryukov 17-Dec-12 0:44am

Why ODBC?!
—SA

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)

Sergey Alexandrovich Kryukov · Answer 1 · 2012-12-16T17:52:00

Solution 1

Basically, you can use ADO.NET with System.Data.Odbc. This is a minimal introductory tutorial:
http://www.easysoft.com/developer/languages/csharp/ado-net-odbc.html[^].

—SA

Posted 16-Dec-12 17:52pm

Sergey Alexandrovich Kryukov

Comments

Rachna0309 17-Dec-12 0:05am

Is there ant other way??This doesnt work.

Sergey Alexandrovich Kryukov 17-Dec-12 0:32am

Is there a different attitude? Yours does not work. You need to do the effort to make things work. This is a right way, and it works.
—SA

Rachna0309 17-Dec-12 0:53am

Thanks..

Sergey Alexandrovich Kryukov 17-Dec-12 1:06am

You are welcome.
—SA

Ashok19r91d 17-Dec-12 0:42am

Use OleDb method to work with .Net and Access, OleDb Not require any DSN so you can just distribute Your app with DB and .Net FW.

Sergey Alexandrovich Kryukov 17-Dec-12 0:44am

It depends on the providers a particular database product has, but this is generally a right idea, of course. I just answered on ODBC, but, come to think about, I should have first questioned: why ODBC.
—SA