Re: SqlCommandBuilder

That was probably one of the worst emails, grammar-wise, I have constructed
in a while.


___________
Vince P  http://66.93.114.145/vince/

MSN Messenger: this address
AIM: pacelvi

"Nobody said it'd be easy. Nobody said that it would be this hard." -
Coldplay


-----Original Message-----
From: Discussion forum for developers using Windows Forms to build apps and
controls [mailto:DOTNET-WINFORMS@xxxxxxxxxxxxxxxxxxx] On Behalf Of Vince P
Sent: Wednesday, 25 February, 2004 09:15
To: DOTNET-WINFORMS@xxxxxxxxxxxxxxxxxxx
Subject: [DOTNET-WINFORMS] SqlCommandBuilder

One of my WinForms is throw up errors about Dynamic SQL not being authorized
on users who aren't DB Admins.

This particular WinForm uses a class in my data tier that uses a
SqlCommandBuilder to retreive SqlParameters of a SqlDataAdapter (of a Stored
Procedure)  (note: the form and data tier are running user's box, the DB
itself is remote)

I'm going to work under the assumption the SqlCommandBuilder is using the
User's Windows identity to run some Sql against the DB tables, and since
those users don't have table access, the error is being thrown.



___________
Vince P  http://66.93.114.145/vince/

MSN Messenger: this address
AIM: pacelvi

"Nobody said it'd be easy. Nobody said that it would be this hard." -
Coldplay