php-windows Digest 3 Mar 2004 08:17:28 -0000 Issue 2147
Topics (messages 23027 through 23040):
Re: start an external program (isqlw.exe)
23027 by: Svensson, B.A.T. (HKG)
23028 by: Gerardo Rojas
23029 by: Svensson, B.A.T. (HKG)
23030 by: Ignatius Reilly
23031 by: Gerardo Rojas
23032 by: Svensson, B.A.T. (HKG)
23033 by: Gerardo Rojas
23034 by: Gerardo Rojas
23038 by: Meteorlet Woody
teehing troubles with PHP
23035 by: Mike
23036 by: Mike
23037 by: Mike
Windows 2003 and SQL Server issues
23039 by: Charles P. Killmer
23040 by: Svensson, B.A.T. (HKG)
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
--- Begin Message ---
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: [EMAIL PROTECTED]
>
--- End Message ---
--- Begin Message ---
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: [EMAIL PROTECTED]
-----Original Message-----
From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 02, 2004 11:14 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-WIN] 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: [EMAIL PROTECTED]
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
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: [EMAIL PROTECTED]
>
>
> -----Original Message-----
> From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 02, 2004 11:14 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-WIN] 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: [EMAIL PROTECTED]
> >
--- End Message ---
--- Begin Message ---
Were you using MySQL, you could do it nicely with phpMyAdmin.
Ignatius
_________________________
----- Original Message -----
From: "Gerardo Rojas" <[EMAIL PROTECTED]>
To: "Svensson, B.A.T. (HKG)" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Tuesday, March 02, 2004 18:17
Subject: RE: [PHP-WIN] start an external program (isqlw.exe)
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: [EMAIL PROTECTED]
-----Original Message-----
From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 02, 2004 11:14 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-WIN] 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: [EMAIL PROTECTED]
>
--
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
--- End Message ---
--- Begin Message ---
the executable is "isqlw.exe" the arguments are -S server -U userid -P password.
--
Gerardo S. Rojas
mailto: [EMAIL PROTECTED]
-----Original Message-----
From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 02, 2004 11:23 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-WIN] 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: [EMAIL PROTECTED]
>
>
> -----Original Message-----
> From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 02, 2004 11:14 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-WIN] 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: [EMAIL PROTECTED]
> >
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
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: [EMAIL PROTECTED]
>
>
> -----Original Message-----
> From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 02, 2004 11:23 AM
> To: [EMAIL PROTECTED]
> Subject: RE: [PHP-WIN] 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: [EMAIL PROTECTED]
> >
> >
> > -----Original Message-----
> > From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, March 02, 2004 11:14 AM
> > To: [EMAIL PROTECTED]
> > Subject: Re: [PHP-WIN] 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: [EMAIL PROTECTED]
> > >
--- End Message ---
--- Begin Message ---
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: [EMAIL PROTECTED]
-----Original Message-----
From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 02, 2004 11:31 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-WIN] 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: [EMAIL PROTECTED]
>
>
> -----Original Message-----
> From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 02, 2004 11:23 AM
> To: [EMAIL PROTECTED]
> Subject: RE: [PHP-WIN] 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: [EMAIL PROTECTED]
> >
> >
> > -----Original Message-----
> > From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, March 02, 2004 11:14 AM
> > To: [EMAIL PROTECTED]
> > Subject: Re: [PHP-WIN] 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: [EMAIL PROTECTED]
> > >
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
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: [EMAIL PROTECTED]
-----Original Message-----
From: Gerardo Rojas [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 02, 2004 11:36 AM
To: Svensson, B.A.T. (HKG); [EMAIL PROTECTED]
Subject: RE: [PHP-WIN] 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: [EMAIL PROTECTED]
-----Original Message-----
From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 02, 2004 11:31 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-WIN] 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: [EMAIL PROTECTED]
>
>
> -----Original Message-----
> From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 02, 2004 11:23 AM
> To: [EMAIL PROTECTED]
> Subject: RE: [PHP-WIN] 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: [EMAIL PROTECTED]
> >
> >
> > -----Original Message-----
> > From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, March 02, 2004 11:14 AM
> > To: [EMAIL PROTECTED]
> > Subject: Re: [PHP-WIN] 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: [EMAIL PROTECTED]
> > >
--
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
--- End Message ---
--- Begin Message ---
Gerardo Rojas,Hello！
If your PHP don't work under safe mode,you can try ` operater.
$str = `isqlw -s -u:root -p`; // maybe it will return the result of
executing.I'm not sure...
======= 2004-03-03 01:35:44 =======
>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: [EMAIL PROTECTED]
>
>
>-----Original Message-----
>From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, March 02, 2004 11:31 AM
>To: [EMAIL PROTECTED]
>Subject: RE: [PHP-WIN] 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: [EMAIL PROTECTED]
>>
>>
>> -----Original Message-----
>> From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]
>> Sent: Tuesday, March 02, 2004 11:23 AM
>> To: [EMAIL PROTECTED]
>> Subject: RE: [PHP-WIN] 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: [EMAIL PROTECTED]
>> >
>> >
>> > -----Original Message-----
>> > From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]
>> > Sent: Tuesday, March 02, 2004 11:14 AM
>> > To: [EMAIL PROTECTED]
>> > Subject: Re: [PHP-WIN] 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: [EMAIL PROTECTED]
>> > >
>
>--
>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
= = = = = = = = = = = = = = = = = = = =
Meteorlet Woody
[EMAIL PROTECTED]
2004-03-03
--- End Message ---
--- Begin Message ---
I'm studying Information systems at university, and I've been set an
assignment to create a simple website using PHP and MySQL. I'm installed
them on my comp at home running Win XP with IIS as my web server. I've
successfully run ASP pages on this set-up but when I try to run a simple
test PHP script - echo ('Hello World'); - all I get is a blank page. But if
I view the source of this page it appears to be fine. I've tried saving the
source of this 'blank' page as HTML and opening it directly in my browser
(IE) but I still get a blank, however if I open this HTML page in FrontPage
and preview it, it's fine. Can anyone suggest anything?
--- End Message ---
--- Begin Message ---
excuse the date on previous post - should be correct on this one
--- End Message ---
--- Begin Message ---
you can ignore this it's working now. the problem was with my
typing/spelling not my software
--- End Message ---
--- Begin Message ---
I am having trouble configuring PHP 4.3.4 on Windows Server 2003 to
connect to SQL Server 2000 on a Windows 2003 Server across the LAN.
Now PHP is configured correctly because when I run the script from the
command line, ie c:\php\php.exe c:\site\file.php, I get the results from
the query.
Its a simple select count(*) from table query.
When I request the same file through a browser I get the error "PHP
Warning: mssql_connect(): Unable to connect to server: ServerName"
If I change the script to just echo phpinfo(); I get everything I would
expect. Extensions are in the right spot, mssql.dll is loaded...
This tells me that IIS 6.0 is configured to run the php.exe. The
command line test tells me that php is configured to connect to the
database. It seems to be that only when IIS tries to run the code to
connect to the database that I run into issues. Possibly an issue of
Windows 2003 being too secure in some area to allow the webuser to
connect to the database server. I have tried changing from the
predefined "Network
Has anyone run into issues with something like this? Thank you for any
help on this.
Charles Killmer
Netgain Technology
[EMAIL PROTECTED]
Office: (320) 251-4700 ext 107
--- End Message ---
--- Begin Message ---
Is the web server located at the same machine as MS SQL server?
Does it work with isql.exe (command line version) to connect to
MS SQL server?
-----Original Message-----
From: Charles P. Killmer
To: [EMAIL PROTECTED]
Sent: 2004-03-03 02:19
Subject: [PHP-WIN] Windows 2003 and SQL Server issues
I am having trouble configuring PHP 4.3.4 on Windows Server 2003 to
connect to SQL Server 2000 on a Windows 2003 Server across the LAN.
Now PHP is configured correctly because when I run the script from the
command line, ie c:\php\php.exe c:\site\file.php, I get the results from
the query.
Its a simple select count(*) from table query.
When I request the same file through a browser I get the error "PHP
Warning: mssql_connect(): Unable to connect to server: ServerName"
If I change the script to just echo phpinfo(); I get everything I would
expect. Extensions are in the right spot, mssql.dll is loaded...
This tells me that IIS 6.0 is configured to run the php.exe. The
command line test tells me that php is configured to connect to the
database. It seems to be that only when IIS tries to run the code to
connect to the database that I run into issues. Possibly an issue of
Windows 2003 being too secure in some area to allow the webuser to
connect to the database server. I have tried changing from the
predefined "Network
Has anyone run into issues with something like this? Thank you for any
help on this.
Charles Killmer
Netgain Technology
[EMAIL PROTECTED]
Office: (320) 251-4700 ext 107
--- End Message ---
