I am trying to connection the Excel file,and use Visual Studio IIS Express can open it,
But use the Internet Information Services can’t open it,
The architecture is like this
computer(IIS) –> share server(Excel) –> computer(IIS) localhost/web X
string connectionString = “provider=Microsoft.ACE.OLEDB.12.0; Data Source=\shareserverXXXX.xlsx ; Extended Properties = “Excel 12.0 Xml;HDR=yes; IMEX = 1″”;
computer(visual Studio) –> share server(Excel) –> computer(IIS) localhost/web O
string connectionString = “provider=Microsoft.ACE.OLEDB.12.0; Data Source=\shareserverXXXX.xlsx ; Extended Properties = “Excel 12.0 Xml;HDR=yes; IMEX = 1″”;
computer(IIS) well show
Failure crearing file
Error :
connection.open()
like can’t foud the file.
Visual Studio IIS Express and Internet Information Services it’s the same code.
change the application pools 32bit true False .
and ask the share Server supplier then don’t know why.
macro is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.