May 23, 2002 at 5:42 am
I have a application role which works fine in my vb6 application where I use
disconnected recordsets in a grid when I am connected using a SQL-userid.
(the switch to the application role works fine)
When I change the connection string to be using SSPI, the update batch fails
saying data will be truncated.
Anyone detected this already ?
What's the solution ?
Jobi
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
May 23, 2002 at 5:57 am
Can you post the full error message, I don't use Application roles and have not heard anything on this, but with the message I can search several locations to see if anyone else has anything.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 23, 2002 at 6:13 am
I dont use them either. I had heard (but not tested for myself) that some controls open a second connection and have problems with application roles. In this case it seems more like a coincidence, that it was data related? If you can duplicate it I'd recommend profiling to see exactly what is being sent over.
Andy
May 23, 2002 at 6:48 am
Stop searching, the "problem" is solved. The application developer actualy defined a table-column to short for the data that would be placed into it.
Thanks anyway for all your efforts.
🙁 these issues are to be considered normal when you work in an organization that does not want to do proper data-analysis and data-definition management because TTM is a priority (?) 🙁
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply