Got this to work, but my problem now is that this will only open windows on the machine hosting the WebServer, is there a way to open an application on the client side?
also had to make some changes to IIS. Logon Tab, check the box where it says "allow service to interact with desktop"
my code goes here
-----------------------------------------------
$ip = $_SERVER['QUERY_STRING'];
$program = "start \"Query Analyzer\" /D\"c:\\Program Files\\Microsoft SQL Server\\80\\Tools\\binn\" /NORMAL isqlw.exe -S$ip -Umyuserid -Pmypassword";
$aOutput = array();
$retval = 0;
echo "<br>program = $program";
exec($program, $aOutput, $retval);
foreach($aOutput as $val )
{
echo "<br>value = $val";
}
echo "<br>Dumping retval = $retval";
-------------------------------------------------
--
Gerardo S. Rojas
mailto: grojas@xxxxxxxxxxxxxxxx
-----Original Message-----
From: Gerardo Rojas [mailto:grojas@xxxxxxxxxxxxxxxx]
Sent: Tuesday, March 02, 2004 11:36 AM
To: Svensson, B.A.T. (HKG); php-windows@xxxxxxxxxxxxx
Subject: RE: start an external program (isqlw.exe)
No, the "isqlw.exe" is the full SQL Query Analyzer tool. I have the full path and executable name. I just don't know how to call it (exactly) from within PHP.
--
Gerardo S. Rojas
mailto: grojas@xxxxxxxxxxxxxxxx
-----Original Message-----
From: Svensson, B.A.T. (HKG) [mailto:B.A.T.Svensson@xxxxxxx]
Sent: Tuesday, March 02, 2004 11:31 AM
To: php-windows@xxxxxxxxxxxxx
Subject: RE: start an external program (isqlw.exe)
For system(), etc , you need executable right for the default command
shell, and you might like to do "start isql.exe ..." besides, you might
also need to include the full path(??).
There are some other function calls that also might be better suited to
fork with... but let me have a check tomorrow (time to leave work)
Anyhow, isqlw.exe, isn't that the plain windows version of isql.exe,
i.e. /not/ the analyzer but the simplified version of it?
On Tue, 2004-03-02 at 18:25, Gerardo Rojas wrote:
> the executable is "isqlw.exe" the arguments are -S server -U userid -P password.
>
>
> --
> Gerardo S. Rojas
> mailto: grojas@xxxxxxxxxxxxxxxx
>
>
> -----Original Message-----
> From: Svensson, B.A.T. (HKG) [mailto:B.A.T.Svensson@xxxxxxx]
> Sent: Tuesday, March 02, 2004 11:23 AM
> To: php-windows@xxxxxxxxxxxxx
> Subject: RE: start an external program (isqlw.exe)
>
>
> Aha, that makes sense! :)
>
> Very well, anyway.. .from time to time I tried to locate the executable
> for this, but failed (could not identify it in "$MSSQL_HOME\binn". I
> also been way to lazy with this (no urgent need as to say). Maybe to
> check the properties of start menu item will help(?), but am not so sure
> about that...
>
> In any case, if you find out, would you please save me some time as well
> and let me know?
>
> On Tue, 2004-03-02 at 18:17, Gerardo Rojas wrote:
> > I have many different SQL Servers that i connect to. This way with PHP (webserver) i can generate a list and quickly pick the one I want and connect to it (also passing the userid and password, this seems like a faster way to do it)
> >
> >
> > --
> > Gerardo S. Rojas
> > mailto: grojas@xxxxxxxxxxxxxxxx
> >
> >
> > -----Original Message-----
> > From: Svensson, B.A.T. (HKG) [mailto:B.A.T.Svensson@xxxxxxx]
> > Sent: Tuesday, March 02, 2004 11:14 AM
> > To: php-windows@xxxxxxxxxxxxx
> > Subject: Re: start an external program (isqlw.exe)
> >
> >
> > Why the do you want to do this with php????
> >
> >
> > On Tue, 2004-03-02 at 17:29, Gerardo Rojas wrote:
> > > Is there a quick way to start the "Query Analyzer" from within PHP?
> > > I've tried exec() and system() with no success.
> > >
> > >
> > > --
> > > Gerardo S. Rojas
> > > mailto: grojas@xxxxxxxxxxxxxxxx
> > >
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
