vb6 & sql7sp2 & application role & update batch
-
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
-
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)
-
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
-
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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply