I WILL ILUSSTERATE MY PROPLEM IN STEPS TO BE FULLY EXPLAINED BEARING IN MIND THAT THE SERVER COMPUTER WILL TAKE NAME 'A' AND THE REMOTE COMPUTER WILL TAKE THE NAME 'B'
1-I INSTALLED SQL 2012 ON 'A' AND FULLY CONFIGURED IT TO PERMIT AND PERFORM THIS QUERY FROM THE SERVER COMPUTER='A' & I RAN IT SUCCEFULY
SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.15.0','Excel12.0;Database=C:\Users\Administrator\Desktop\test.xlsx;HDR=YES;IMEX=1', 'SELECT * FROM [Sheet1$]')
2- FROM A REMOTE COMPUTER='B' I INSTALLED SQL2012 ALSO AND I CONFIGURED IT TO ALLOW OPENROWSET QUERY; NOW THE PROMBLEM COMES WHEN I BE ON THE REMOTE COMPUTER='B' AND I CONNECT SUCCSSEFULY TO THE REMOTE SERVER AND RUN THE SAME QUERY IT GIVES ME THE FOLLOWING ERROR
"Msg 7302, Level 16, State 1, Line 1
Cannot create an instance of OLE DB provider "Microsoft.ACE.OLEDB.15.0" for linked server "
3- WHEN I BE ON THE REMOTE COPUTER='B' AND I RUN THE SAME QURY UNDER THE LOCAL ACCOUNT OF SQL SERVER OF THE REMOTE COMPUTER I ALSO RUN IT SUCCSSEFULLY BUT AGAIN IF I RECONNECT REMOTLY TO THE SERVER OF COMPUTER A AND I RAN I IT FAILS.
** I AM USING WINDOWS7 LITE X32
** I INSTALLED OFFICE2013 ON BOOTH
** I HAVE THE PERMISSIONS TO WRITE AND READ ON THE TEMP FOLDER
** I ENABLED DISTRIBUTED QUERIES AND AllowInProcess AND DynamicParameters
CAN U PLZ HELP ME
What I have tried:
** I AM USING WINDOWS7 LITE X32
** I INSTALLED OFFICE2013 ON BOOTH
** I HAVE THE PERMISSIONS TO WRITE AND READ ON THE TEMP FOLDER
** I ENABLED DISTRIBUTED QUERIES AND AllowInProcess AND DynamicParameters