i execute the following statement succesfully:
select * from OPENROWSET('MSDASQL','DSN=Mistral_Gemas',
'SELECT * FROM Clients')
but i'm not able to run it succesfully again after 1 minute. everytime i execute it before the minute the following error message is shown :
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)".
i don't think is a permission issue, rather a locked file issue or something...any ideas?...thanks in advance