i get error when run the line below
FullFilePath='//192.168.7.7/ExportExcel/ComplianceSample.xlsx'
excel_header = list(pd.read_excel(FullFilePath).columns)
error details
Error in execution. Check the output for more information. Traceback (most recent call last): File "", line 5, in File "D:\ProgramData\MSSQLSERVER\Temp-PY\Appcontainer1\6D0E822A-D7E1-4DCE-BAB5-449D89FEAD53\sqlindb_0.py", line 49, in transform excel_header = list(pd.read_excel(FullFilePath).columns) File "D:\SQL Data\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\pandas\util\_decorators.py", line 178, in wrapper return func(*args, **kwargs) File "D:\SQL Data\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\pandas\util\_decorators.py", line 178, in wrapper return func(*args, **kwargs)
Msg 39019, Level 16, State 2, Line 1 An external script error occurred: File "D:\SQL Data\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\pandas\io\excel.py", line 307, in read_excel io = ExcelFile(io, engine=engine) File "D:\SQL Data\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\pandas\io\excel.py", line 394, in __init__ self.book = xlrd.open_workbook(self._io) File "D:\SQL Data\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\xlrd\__init__.py", line 111, in open_workbook with open(filename, "rb") as f: PermissionError: [Errno 13] Permission denied: '//192.168.7.7/ExportExcel/ComplianceSample.xlsx'
when fullpath= \\192.168.7.7\ExportExcel\ComplianceSample.xlsx
issue display but if fullpath=D:\ExportExcel\ComplianceSample.xlsx
issue not display
so how to solve this issue please
why i can read from local path
and by ip can't read file
I need mandatory shared path because i can't access shared path from another pc
What I have tried:
I give access to folder ExportExcel to have everyone permission and all_packages and give full control and read and write
also i can open this path from server 7.7 \\192.168.7.7\ExportExcel\ComplianceSample.xlsx
sql server 2017 and python and files all exist on server 7.7
when make run from start menu and write path \\192.168.7.7\ExportExcel\ComplianceSample.xlsx i can open path
also i can read write on path above .
also path folder ExportExcel give it every one permission and admins permission
so How to solve issue please