MySQLAdapters - inconsistent permissions?
Posted by: Luke Briner
Date: September 14, 2006 10:49AM

I have setup a connection to a MySQL DB from a .Net app using an adaptor to call a stored procedure. Initially I used:

adapter.SelectCommand = new MySqlCommand(@"CALL GetPatient(' etc.

and this worked fine. However, after seeing a page here that suggested using

adapter.CommandText="GetPatient";
adapter.CommadType = CommandType.StoredProcedure;
etc..

I am not permitted to call adapter.Fill( myDataSet ); with an exception along the lines of "User Luke not permitted to access table 'proc'"

Is this correct? I prefer the first style anyway because the second is about 7 lines longer!!

Options: ReplyQuote


Subject
Written By
Posted
MySQLAdapters - inconsistent permissions?
September 14, 2006 10:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.