i have a stored procedure and when i am running it in the sql 2005, it will exexute successful and no proplem. but when i a mputting it in my report service as my dataset it is giving me error 207, invalid column.
i checked it hundred times and all the names are right and it is existing but why it is giving me this error?
thanks alot for any helpproblem solved,
thanks|||
Quote:
Originally Posted by voroojak
problem solved,
thanks
it will happen, when specify the field name is not correct or unknown field name
from a table in reports or qrey.
(just post how it solved if it solved)
thankyou|||Thanks for your consideration.
in my Stored procedures i was inserting into other table in another database. I mean i was getting value from one database and and wante dto i nsert in another database, the problem was that the name of the columns that i was trying to insert to was not same.
i mean in my first database all the names when they are naming is like first_name but in the second one it was first name. and i was not checking the format of the second data base.
those columns that it was giving me a message that it is invalid, i had it along my stored procedures a lot and i was thinking there is a problem in reaniming my columns or something else.
i hope i could explain it properly.
No comments:
Post a Comment