connection problem in windows base C# program

Question

5.00/5 (1 vote)

See more:

Hi All,

I have a windows based C# application. When I try to input details in login page, it shows the error below.

 private void button1_Click(object sender, EventArgs e)
        {

            try
            {


                con.ConnectionString = Microsoft.VisualBasic.Strings.Trim(obj.connection().ToString());
                con.Open();
                string qry;
                qry = "select * from admin";
                OdbcCommand cmd = new OdbcCommand(qry, con);
                OdbcDataAdapter ad = new OdbcDataAdapter();
                DataSet ds = new DataSet();
                ad.SelectCommand = cmd;
                ds = new DataSet();
                ad.Fill(ds, "admin");  
//here it direct goes to catch block 

catch (Exception ex)
            {

and shows -----

ERROR [42S02] [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'admin'.  Make sure it exists and that its name is spelled correctly.

Please help to solve the issue

Thanks & regards

Indrajit

Posted 1-May-11 20:23pm

IndrajitDasgupat

Updated 1-May-11 20:28pm

Pong D. Panda

v2

Add a Solution

4 solutions

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)

Pong D. Panda · Answer 1 · 2011-05-01T20:30:00

Solution 2

Hi, try to check the value of your connection string, the error seems to reside on either the connectionstring missing, or invalid database specified on your connectionstring.

Good luck!

Posted 1-May-11 20:30pm

Pong D. Panda

Comments

IndrajitDasgupat 2-May-11 2:32am

how can I check the connection string please help

Pong D. Panda 2-May-11 2:36am

try putting a breakpoint on the line 'con.Open();' Or do what digital man suggest, put bracket on your select query. Use "select * from [admin]" on your statement.

IndrajitDasgupat 2-May-11 2:38am

How can I check the path of DB from my project
Please help

IndrajitDasgupat 2-May-11 2:43am

Thank U Sir it is working

Pong D. Panda 2-May-11 2:52am

Then mark this question as solved and it would be helpful if you vote up the answer that helped you.
Good luck!

**R. Giskard Reventlov** · Answer 2 · 2011-05-01T20:31:00

Solution 3

The clue is in the exception message: looks like you are connecting but Access can't find a table called 'admin'. Does your database contain a table called 'admin'? Long time since I used Access but try this statement: select * from [admin].

Posted 1-May-11 20:31pm

R. Giskard Reventlov

Comments

IndrajitDasgupat 2-May-11 2:37am

Yes my DB contain table "admin"
How can I check the path of DB from my project
Please help

R. Giskard Reventlov 2-May-11 2:43am

Th epath should be in your connection string. Try putting the db in the same folder as the application so that the path becomes moot and ensure that you have the requisite permissions to open the database: can't help more as it is many years since I played with Access.

SercanOzdemir · Answer 3 · 2011-05-04T00:37:00

Solution 4

There is a mistake about your admin table because you dont have a table named admin.Check your tablename and Table.Also check your connection string it's syntax should be like this :

string bglnyer = "Provider=Microsoft.JET.OLEDB.4.0;Data Source=" + Application.StartupPath + "\\DATABASE.mdb";

Posted 4-May-11 0:37am

SercanOzdemir

Updated 4-May-11 0:40am

v3

Ashishmau · Answer 4 · 2011-05-01T20:28:00

Solution 1

dont use admin as second parameter

u can do like this

MIDL

ad.Fill(ds)

try with this

Posted 1-May-11 20:28pm

Ashishmau