March 24, 2008 at 10:56 am
i have database in sql 2005 with mode 80 and i have turn on setting for ole automation in surface area configuration but still getting an error
0x80131700 ODSOLE Extended Procedure.
Any help is greatly appreciated.
April 23, 2008 at 2:34 am
You haven't given us any details. We can guess, but I'm pretty sure you don't want that. 🙂
What component are you trying to invoke? Is it installed on the server?
Does the component use a user interface? (This is not supported.)
Does the component use a remote resource? Are appropriate permissions set on the remote resource?
ML
---
Matija Lah, SQL Server MVP
http://milambda.blogspot.com
April 24, 2008 at 3:07 am
Is the user trying to use the SP_OA procedures a member of sysadmin? In SQL Server 2005 only members of sysadmin can use SP_OA procs. In SQL Server 2000 you could authorise anyone to use them.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply