Connection to DB2 in .NET

Question

0.00/5 (No votes)

See more:

Hi
I am trying to connect DB2 database in my application I get this error:

"ERROR [42704] [IBM][DB2/NT] SQL0204N "DB2ADMIN.TBL_USER" is an undefined name."

Please help me on solving this error.

C#

string connString = "Database=dbName;userID=usrname;password=pass server=servername";

using (DB2Connection con = new DB2Connection(connString))

            {

                DB2Command cmd = new DB2Command("SELECT * FROM TBL_USER", con);

                DataTable dTable = new DataTable();

                DB2DataAdapter adapter = new DB2DataAdapter(cmd);

                adapter.SelectCommand = cmd;

                adapter.Fill(dTable);  //Error is executed here.

                return dTable;

            }

Posted 15-Oct-12 3:29am

Anele Ngqandu

Add a Solution

Comments

[no name] 15-Oct-12 9:36am

And do you have a table named TBL_USER in your DB2ADMIN database?

Anele Ngqandu 15-Oct-12 9:39am

yes i do sir

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)

Manfred Rudolf Bihy · Accepted Answer · 2012-10-15T03:43:00

Solution 1

I'd guess that the table does in user DB2ADMIN's schema. Try something like this:

DB2Command cmd = new DB2Command("SELECT * FROM dbo.TBL_USER", con);

Where dbo shall be substituted for the schema your table TBL_USER is really in.

Regards,

— Manfred

Might want to read some about schemas: http://publib.boulder.ibm.com/infocenter/zos/basics/index.jsp?topic=/com.ibm.db2z.doc.intro/db2z_schemaqualifiers.html[^]

Posted 15-Oct-12 3:43am

Manfred Rudolf Bihy

Updated 15-Oct-12 3:44am

v2

Comments

Anele Ngqandu 15-Oct-12 9:49am

i am still geting the same error sir

Manfred Rudolf Bihy 15-Oct-12 10:23am

I wrote: "Where dbo shall be substituted ..." Is there anything unclear about that?
Since I can't see your computer screen you'll have to find out yourself what schema TBL_USER belongs to. Why don't you ask your database administrator?

Anele Ngqandu 15-Oct-12 10:27am

I get what you saying sir and I did what you told me to but i get the same results.There is no database administrator am just playing with DB2 here. Am assuming it has to do with privileges thou.

Anele Ngqandu 16-Oct-12 2:26am

Ow my bad,wrote wrong schema name.