The current user does not have permissions on that object.
Hi All,
The web application has no right to access folder at its application folder.
I use Stored Procedure to read file from the folder.
How to solve this ?
Thank you.
Microsoft SQL Server
Last Comment
Vitor Montalvão
8/22/2022 - Mon
Pawan Kumar
What username u are passing from web application?
That one should have access to create the folder and to select the data from the table.
Can u share the store procedure.
emi_sastra
ASKER
Hi Pawan,
Msg 7357, Level 16, State 2, Line 2
Cannot process the object "SELECT * FROM [DATA$]". The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" indicates that either the object has no columns or the current user does not have permissions on that object.
Thank you.
Vitor Montalvão
The SQL Server service account needs to have read and write permissions on the folder. Check if that is true for your case.
That one should have access to create the folder and to select the data from the table.
Can u share the store procedure.