SQL Server blocked access to procedure 'sys.sp_OACreate'

11/07/2007 - 10:06 por Pedro | Informe spam
Estoy exportado a excel y me encuentro con unos errores saben por que puede
ser?
Os dajunto los erreres con un pequeño detalle:

Created OLE ADODB.Connection object
Mens 15281, Nivel 16, Estado 1, Procedimiento sp_OACreate, Línea 1
SQL Server blocked access to procedure 'sys.sp_OACreate' of component 'Ole
Automation Procedures' because this component is turned off as part of the
security configuration for this server. A system administrator can enable the
use of 'Ole Automation Procedures' by using sp_configure. For more
information about enabling 'Ole Automation Procedures', see "Surface Area
Configuration" in SQL Server Books Online.
Assigned ConnectionString property
Mens 15281, Nivel 16, Estado 1, Procedimiento sp_OASetProperty, Línea 1
SQL Server blocked access to procedure 'sys.sp_OASetProperty' of component
'Ole Automation Procedures' because this component is turned off as part of
the security configuration for this server. A system administrator can enable
the use of 'Ole Automation Procedures' by using sp_configure. For more
information about enabling 'Ole Automation Procedures', see "Surface Area
Configuration" in SQL Server Books Online.
Open Connection to XLS, for file Create or Append
Mens 15281, Nivel 16, Estado 1, Procedimiento sp_OAMethod, Línea 1
SQL Server blocked access to procedure 'sys.sp_OAMethod' of component 'Ole
Automation Procedures' because this component is turned off as part of the
security configuration for this server. A system administrator can enable the
use of 'Ole Automation Procedures' by using sp_configure. For more
information about enabling 'Ole Automation Procedures', see "Surface Area
Configuration" in SQL Server Books Online.
Execute DDL to create 'EXCELSQL' worksheet
Mens 15281, Nivel 16, Estado 1, Procedimiento sp_OAMethod, Línea 1
SQL Server blocked access to procedure 'sys.sp_OAMethod' of component 'Ole
Automation Procedures' because this component is turned off as part of the
security configuration for this server. A system administrator can enable the
use of 'Ole Automation Procedures' by using sp_configure. For more
information about enabling 'Ole Automation Procedures', see "Surface Area
Configuration" in SQL Server Books Online.
Destroyed OLE ADODB.Connection object
Mens 15281, Nivel 16, Estado 1, Procedimiento sp_OADestroy, Línea 1
SQL Server blocked access to procedure 'sys.sp_OADestroy' of component 'Ole
Automation Procedures' because this component is turned off as part of the
security configuration for this server. A system administrator can enable the
use of 'Ole Automation Procedures' by using sp_configure. For more
information about enabling 'Ole Automation Procedures', see "Surface Area
Configuration" in SQL Server Books Online.
Created Linked Server 'EXCEL_TEST' and Login
Mens. 121, Nivel 15, Estado 1, Línea 1
The select list for the INSERT statement contains more items than the insert
list. The number of SELECT values must match the number of INSERT columns.
Populated 'EXCELSQL' table with 1 Rows
Deleted Linked Server 'EXCEL_TEST' and Login
 

Leer las respuestas

#1 Pedro
11/07/2007 - 10:24 | Informe spam
Exportacion a XLS mediante ADODB.Connection,

Solucione el anterior problema con:
sp_configure 'Ole Automation Procedures',1
Reconfigure

Ahora tengo el error:
Error 0x800A0E7A
Source: ADODB.Connection
Description: Provider cannot be found. It may not be proerly installed

no entiendo muy bien la descripcion de error, tengo que instalar algo??


"Pedro" wrote:

Estoy exportado a excel y me encuentro con unos errores saben por que puede
ser?
Os dajunto los erreres con un pequeño detalle:

Created OLE ADODB.Connection object
Mens 15281, Nivel 16, Estado 1, Procedimiento sp_OACreate, Línea 1
SQL Server blocked access to procedure 'sys.sp_OACreate' of component 'Ole
Automation Procedures' because this component is turned off as part of the
security configuration for this server. A system administrator can enable the
use of 'Ole Automation Procedures' by using sp_configure. For more
information about enabling 'Ole Automation Procedures', see "Surface Area
Configuration" in SQL Server Books Online.
Assigned ConnectionString property
Mens 15281, Nivel 16, Estado 1, Procedimiento sp_OASetProperty, Línea 1
SQL Server blocked access to procedure 'sys.sp_OASetProperty' of component
'Ole Automation Procedures' because this component is turned off as part of
the security configuration for this server. A system administrator can enable
the use of 'Ole Automation Procedures' by using sp_configure. For more
information about enabling 'Ole Automation Procedures', see "Surface Area
Configuration" in SQL Server Books Online.
Open Connection to XLS, for file Create or Append
Mens 15281, Nivel 16, Estado 1, Procedimiento sp_OAMethod, Línea 1
SQL Server blocked access to procedure 'sys.sp_OAMethod' of component 'Ole
Automation Procedures' because this component is turned off as part of the
security configuration for this server. A system administrator can enable the
use of 'Ole Automation Procedures' by using sp_configure. For more
information about enabling 'Ole Automation Procedures', see "Surface Area
Configuration" in SQL Server Books Online.
Execute DDL to create 'EXCELSQL' worksheet
Mens 15281, Nivel 16, Estado 1, Procedimiento sp_OAMethod, Línea 1
SQL Server blocked access to procedure 'sys.sp_OAMethod' of component 'Ole
Automation Procedures' because this component is turned off as part of the
security configuration for this server. A system administrator can enable the
use of 'Ole Automation Procedures' by using sp_configure. For more
information about enabling 'Ole Automation Procedures', see "Surface Area
Configuration" in SQL Server Books Online.
Destroyed OLE ADODB.Connection object
Mens 15281, Nivel 16, Estado 1, Procedimiento sp_OADestroy, Línea 1
SQL Server blocked access to procedure 'sys.sp_OADestroy' of component 'Ole
Automation Procedures' because this component is turned off as part of the
security configuration for this server. A system administrator can enable the
use of 'Ole Automation Procedures' by using sp_configure. For more
information about enabling 'Ole Automation Procedures', see "Surface Area
Configuration" in SQL Server Books Online.
Created Linked Server 'EXCEL_TEST' and Login
Mens. 121, Nivel 15, Estado 1, Línea 1
The select list for the INSERT statement contains more items than the insert
list. The number of SELECT values must match the number of INSERT columns.
Populated 'EXCELSQL' table with 1 Rows
Deleted Linked Server 'EXCEL_TEST' and Login

Preguntas similares