Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
boreddy
Posting Yak Master
172 Posts |
 Posted - 2008-05-28 : 07:55:57
|
| In my procedure have one insert one update when i run the procedure i am not getting any errorswhen i call that procedure from front end i am getting this message“Implicit conversion from data type ntext to varchar is not allowed. Use the CONVERT function to run this query.” Please help me for this |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-05-28 : 07:59:09
|
| Are you passing same parameters to proc when running from front-end as well as back-end?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-28 : 08:11:30
|
quote:
Originally posted by boreddy
In my procedure have one insert one update when i run the procedure i am not getting any errorswhen i call that procedure from front end i am getting this message“Implicit conversion from data type ntext to varchar is not allowed. Use the CONVERT function to run this query.” Please help me for this
Seems like the value passed for parameter from application does not match with its datatype.Have you tried executing the stored procedure directly in query analyser? |
|
|
|
boreddy
Posting Yak Master
172 Posts |
Posted - 2008-05-28 : 08:49:06
|
| yes i am sending parameters parameters data types are int ,varchar |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-28 : 09:54:15
|
quote:
Originally posted by boreddy
yes i am sending parameters parameters data types are int ,varchar
Did you try running sp directly? |
|
|
|
boreddy
Posting Yak Master
172 Posts |
Posted - 2008-05-28 : 10:13:14
|
| yes i tried running sp directly but i am not getting any error message |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-28 : 10:17:24
|
quote:
Originally posted by boreddy
yes i tried running sp directly but i am not getting any error message
Are you able to find what values were passed by application for varchar parameter while invoking the sp which caused error? Looks like the application was trying to pass some value which couldnt be converted to varchar which caused this error. |
|
|
|
boreddy
Posting Yak Master
172 Posts |
Posted - 2008-05-29 : 03:30:54
|
| here my tbale column datatype is varchar(8000)when i changed to varchar(4000)it is working fine( i am useing SQL server 2000)what size of varchar in SQL server2000 |
|
|
|
|
|
|
Is it related to front end or back end problem