Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Opening IE With Sqlserver code Expand / Collapse
Author
Message
Posted Wednesday, May 26, 2010 10:38 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 27, 2010 1:32 AM
Points: 6, Visits: 7
Hi Friends,

We have to open Internet Explorer using Sql Code in Sqlserver 2005.
And it will automatically open for 5 mins.It has to open through SQLSERVER only.There is no front end..Please Find Corresponding Code for this.Can We use SSIS package here.

Thanks In Adance
Post #928725
Posted Wednesday, May 26, 2010 10:56 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 12, 2014 5:21 PM
Points: 2,262, Visits: 5,406
Write a CLR proc and open up IE.. in the CLR proc u can utilize the Process class and run this code

start iexplore.exe
this code is to open IE from command prompt.
Post #928729
Posted Thursday, May 27, 2010 12:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 27, 2010 1:32 AM
Points: 6, Visits: 7
We Can Use cmd_shell also.

But other than that can we have any solution to open Internet Explorer through sqlcode.

In SSIS package using activeX code can we get.
Post #928758
Posted Thursday, May 27, 2010 1:10 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 8:21 AM
Points: 4,405, Visits: 10,700
It's a crazy requirement.
IE can't open on the client machine, but would only run on the SQL server machine. Is that really what you want?
Can you explain exactly what are you trying here? Maybe there's a better alternative.


--
Gianluca Sartori

How to post T-SQL questions
spaghettidba.com
@spaghettidba
Post #928770
Posted Thursday, May 27, 2010 1:37 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 27, 2010 1:32 AM
Points: 6, Visits: 7
For opening internet explorer We have to write sql code and schedule job for 5 mins.For 5 Mins this job has to take code from the Sqlserver and open internet explorer with certain URL(WWW.GOOGLE.COM).

You Got My Point.
Post #928780
Posted Thursday, May 27, 2010 1:52 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 2:06 AM
Points: 1,768, Visits: 8,318
I have to echo Gianluca, this is crazy. What are you expecting and wanting to achieve.



Clear Sky SQL
My Blog
Kent user group
Post #928787
Posted Thursday, May 27, 2010 6:34 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 8:22 AM
Points: 20,734, Visits: 32,500
First, how about explaining why you MUST open IE in code.

Second, since the SQL Server won't have access to the servers desktop, I really don't see this working.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #928933
Posted Thursday, May 27, 2010 8:05 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 1:11 PM
Points: 12,905, Visits: 32,161
wrong tool for the job.

what are you trying to accomplish? is this a keep alive so your web page stays in the server cache?
what's wrong with calling iexplorer.exe from windows Scheduled tasks once a minute?
why must it be done in SQL?

i notice two different users are asking the same question...this is not a homework assignment, is it?
Opening IE With Sqlserver code


Opening Internet Explorer Using SQL-CODE


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #928996
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse