Opening IE With Sqlserver code

Question

Post reply

Opening IE With Sqlserver code

abhidbasql

SSC Enthusiast

Points: 100
More actions
May 26, 2010 at 10:38 pm

#225075

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

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

ColdCoffee SSC-Dedicated Points: 39971 More actions · Answer 1

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.

abhidbasql SSC Enthusiast Points: 100 More actions · Answer 2

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.

spaghettidba SSC Guru Points: 105732 More actions · Answer 3

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

abhidbasql SSC Enthusiast Points: 100 More actions · Answer 4

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.

Dave Ballantyne SSC-Dedicated Points: 33566 More actions · Answer 5

I have to echo Gianluca, this is crazy. What are you expecting and wanting to achieve.

Clear Sky SQL
My Blog[/url]

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 6

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.

Lowell SSC Guru Points: 323504 More actions · Answer 7

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

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!