Error with retrieving data
Hi all,
I'm getting an error when filling a dataset, but I can't figure out why. code is:
VB Code:
TreeAdapter.Fill(TreeData.Qry_Admin_TreeMenu_VBNET)
And the error I get is:
An unhandled exception of type 'System.data.sqlclient.sqlexception' occurred in system.data.dll
Additional Information: System Error
How can I resolve this error? I think it might be sql server is giving the error, how can I get the application to give me the error in a messagebox?
Thanks
Rudi
Re: Error with retrieving data
DO this:
VB Code:
Try
TreeAdapter.Fill(TreeData.Qry_Admin_TreeMenu_VBNET)
Catch ex As System.data.sqlclient.sqlexception
MEssageBox ex.ToString
End Try
That will tell you what SQL Server is returning as the error.
Tg
Re: Error with retrieving data
Ok I got the error, it's sql errors... but not one that I like....
Execute permission denied on 'sp_sdidebug' on the master database.
What does that sp do?
I don't really want to give my users access to my master database..... Will it harm my server?
Regards,
Rudi