ole automation - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

ole automation

Author

Topic

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2008-07-16 : 06:36:48

Using sql, Do you know how to enable the ole automatin in surface area configuration?
There does not seem to be anything about this in books online.
Thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-07-16 : 07:23:54

Wanna bet?

sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO

sp_configure 'Ole Automation Procedures'
GO

sp_configure 'show advanced options', 0
RECONFIGURE
GO

E 12°55'05.25"
N 56°04'39.16"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-07-16 : 07:35:10

1. SQL Server 2005 Surface Area Configuration -> Surface Area Configuration for Features
2. OLE Automation

E 12°55'05.25"
N 56°04'39.16"

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2008-07-16 : 08:04:12

Many thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-07-16 : 08:07:50

Next time, you might want to use Google or Books Online before posting a trivial question?

E 12°55'05.25"
N 56°04'39.16"

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2008-07-16 : 08:20:08

I really did search on line but could not get the sql for it.
Thanks anyway.

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2008-07-16 : 08:27:56

I have now tested the sp_configure as you suggested.
It does not seem to make a difference to the checkbox in the oleAutomation.
Either way it is always set to checked unless I manually uncheck it.
Any thoughts please?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-07-16 : 08:51:20

If it is checked, OLE Automation is enabled.
If it is not checked, OLE Automation is disabled.

E 12°55'05.25"
N 56°04'39.16"

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2008-07-16 : 08:59:07

I would like to have it the other way round i.e.
When enabled i.e. 1 then it should be checked
when disabled i.e. 0 then it should be unchecked
It does not seem to be doing that.
Thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-07-16 : 09:08:43

If you want change the value for OLE Automation in SQL Surface Area Configuration,
you also have to click OK or APPLY.

Just changing the value is not enough.

E 12°55'05.25"
N 56°04'39.16"

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2008-07-16 : 09:12:57

I think you mis-understood.
I would like to change the setting of the checkbox using only SQL. i.e. sp_configure
I do not want to do this in the surface area window.
Thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-07-16 : 09:14:38

You are writing a SQL injection application?
What is wrong with the method I showed earlier? Read the post 07/16/2008 : 07:23:54 again and please make an effort yourself, you lazy bastard

I showed you how to alter a setting and viewing a setting with t-sql code.

E 12°55'05.25"
N 56°04'39.16"

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2008-07-16 : 09:46:49

:-) ok
Just to confirm, the sql code should change the setting in surface area ole automation checkbox, right?
I have done this already but the checkbox does not change it's state whereas after running the sql, it does give a message in query analyser that the setting has changed.
Thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-07-16 : 09:50:39

It is because the setting for OLE Automation is only viewed, not altered.
Do you see the difference between the uses of sp_configure?

E 12°55'05.25"
N 56°04'39.16"

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2008-07-16 : 10:00:41

After reading about sp_configure and looking at the sql provided earlier I thought the settings can be altered i.e. enabled to disabled or vice versa.
Not sure what you mean by only viewed, not altered. I am not sure what you mean by only viewed because the sql analyser shows the setting changed from 0 to 1 or vice versa.
Thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-07-16 : 10:12:45

quote:
Originally posted by arkiboys

... the sql analyser shows the setting changed from 0 to 1 or vice versa.

Really?

E 12°55'05.25"
N 56°04'39.16"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-07-16 : 10:14:09

What have you read about the minimum and maximum columns for sp_configure?
What have you read about the config_value and run_value columns for sp_configure?

E 12°55'05.25"
N 56°04'39.16"

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2008-07-16 : 10:17:31

This is what I ran
sp_configure @configname = 'show advanced options', @configvalue = 1
GO
RECONFIGURE
GO

sp_configure 'Ole Automation Procedures'
GO

sp_configure 'show advanced options', 0
RECONFIGURE
GO
and the result in analyser is:
Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-07-16 : 10:20:53

Which option, did you say you changed?
It is not the 'Ole Automation Procedures' for what I can tell.

E 12°55'05.25"
N 56°04'39.16"

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-07-16 : 10:22:18

sp_configure 'Ole Automation Procedures', 1;

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.0 out!

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-07-16 : 10:23:07

Nooooo......

E 12°55'05.25"
N 56°04'39.16"

Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources