May 26, 2010 at 10:38 pm
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
May 26, 2010 at 10:56 pm
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.
May 27, 2010 at 12:26 am
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.
May 27, 2010 at 1:10 am
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
May 27, 2010 at 1:37 am
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.
May 27, 2010 at 1:52 am
I have to echo Gianluca, this is crazy. What are you expecting and wanting to achieve.
May 27, 2010 at 6:34 am
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.
May 27, 2010 at 8:05 am
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
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply