Hi All,

I have got the starnge solutions for the strange problem. Till now it is working perfectly.

As I said, the SQL execution would not give error untill I use any...

Hi Sean Lange,

When I execute the following code you suggested, I get the same error saying "SELECT permission denied on the object....."

ADOQuery3.Close;

ADOQuery3.SQL.Clear;

ADOQuery3.SQL.Add('select 1 as Test into #MyTable');

ADOQuery3.ExecSQL; //Getting error when...

Hi Sean Lange And Hi Dear All,

Hi Sean, I would execute the way you said and then I would come back to you, following thing I am writting before reading...

I don't get any error. Means role is set.

With Best Regards.

Vishal

Yes, that's why first time there is no error.

With Best Regards.

Vishal

Hi,

I have kept one TADOConnection component and 2 TADOQuery components and one TButton component at design time.

I have written the code at two places:

1. FormShow event:

Here I am...

Hi Sean Lange,

I have already mention in the thread as follows:

When I execute the first sql then it works fine without any error, but when I execute the second sql...