September 23, 2010 at 11:11 am
Hello eveyone,
I have the following procedure:
Insert into CanadaReport (Process,SubProcess,ReferenceNumber,EmployeeID,EmployeeName,SystemInput,ActualStart,ActualFinish,ReceivedDate,Status,Owner,Requestor,EmployeeLocation,HRBP,EmployeeManagerName,EEGroup,EESubgroup,VacationQuantity,IncentivePlan,PeopleManager,ManagerName,Auditor,InsertedBy,Notes)
Select Process,SubProcess,ReferenceNumber,EmployeeID,EmployeeName,SystemInput,ActualStart,ActualFinish,ReceivedDate,Status,Owner,Requestor,EmployeeLocation,HRBP,EmployeeManagerName,EEGroup,EESubgroup,VacationQuantity,IncentivePlan,PeopleManager,ManagerName,Auditor,InsertedBy,Notes
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\MCBC_Canada\MCBC_Canada_Upload.xls;HDR=YES',
'SELECT * FROM [Canada$]')
And I am getting the clasic error that says:SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' .
I already enable it on the surface area config and also I did it by SP.
Ad Hoc Distributed Queries0111
I am running sql express, vs 2008, server 2008...Please help!
Also I will like to add that if I run the command from the SQL query inside Visual Studio2008 it runs perfectly...I just cannot call the procedure outside de query editor.
September 23, 2010 at 11:18 am
Someone please?!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply