Solved

Number of bound columns exceeds the number of result columns

Posted on 2004-08-30
10
2,086 Views
Last Modified: 2008-01-09
Number of bound columns exceeds the number of result columns
0
Comment
Question by:mahender612
  • 3
  • 2
10 Comments
 
LVL 29

Expert Comment

by:leonstryker
Comment Utility
What is the question?
0
 

Author Comment

by:mahender612
Comment Utility
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
 
LVL 29

Expert Comment

by:leonstryker
Comment Utility
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
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 
LVL 6

Accepted Solution

by:
ChrisKing earned 50 total points
Comment Utility
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
 
LVL 29

Expert Comment

by:leonstryker
Comment Utility
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
 
LVL 6

Expert Comment

by:ChrisKing
Comment Utility
Why wouldn't he, this is what that error means !
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Marketing can be an uncomfortable undertaking, especially if your material is technology based. Luckily, we’ve compiled some simple and (relatively) painless tips to put an end to your trepidation and start your path to success.
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video discusses moving either the default database or any database to a new volume.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now