Click here to Skip to main content
15,879,474 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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
Posted
Updated 28-Aug-16 1:19am

 
Share this answer
 
Comments
محمد شهاب الدين 28-Aug-16 6:34am    
it is correctly configured aas the link state to 1 on both computers although i stil fail.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900