Solved

Number of bound columns exceeds the number of result columns

Posted on 2004-08-30
10
2,141 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
ID: 11934007
What is the question?
0
 

Author Comment

by:mahender612
ID: 11934269
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
ID: 11934353
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 6

Accepted Solution

by:
ChrisKing earned 50 total points
ID: 11938332
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
ID: 11943637
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
ID: 11947896
Why wouldn't he, this is what that error means !
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Scenario: Your operations manager has discovered an anomaly in your security system. The business will start to suffer within 15 minutes if it is a major IT incident. What should she do? We have 6 recommendations for managing major incidents (https:…
With the rapid rise in mobile usage, mobile devices are here to stay and have become an integral part of doing business. Here are 9 great apps for your BYOD environment.
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

895 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

14 Experts available now in Live!

Get 1:1 Help Now