Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2419
  • Last Modified:

Number of bound columns exceeds the number of result columns

Number of bound columns exceeds the number of result columns
0
mahender612
Asked:
mahender612
  • 3
  • 2
1 Solution
 
leonstrykerCommented:
What is the question?
0
 
mahender612Author Commented:
I am getting an error message like : "Number of bound columns exceeds the number of result columns"
when I ran a session from informatica to query a table in sybase using ODBC. Session is failing because of above error.
0
 
leonstrykerCommented:
First thing you need to do is post a question to the Community Support area to have them un-accept the answer.

Lets take a look at your query.

Leon
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
ChrisKingCommented:
Count the columns in your result set, then count the number of bound columns in your application.

You will find that they don't match, (eg 5 columns in the result set, application expect 6 columns)
0
 
leonstrykerCommented:
ChrisKing, you should have guessed this was gooing to happen from the previous posts. :)

mahender612, would you please explain the grade you gave to ChrisKing. :(

Leon
0
 
ChrisKingCommented:
Why wouldn't he, this is what that error means !
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now