Problems With MS-SQL, Apace, PHP On Windows 2000
I want to use PHP for a project at work. This project requires Windows 2000 running Apache and accessing MS-SQL Server 2000. I am using the mssql php extension to access the db and have all the required files to access the db. If the environment was not correct, it shouldn't connect and successfully query int data types.
Everything works fine as long as I query for numeric datatypes such as int. However, every single time I try to query a text, char, var or datetime field, Apache crashes and I get a Windows error dialog saying that an error is being logged. Unfortunately, there is no error logged to either the Windows 2000 Event Log or the Apache log.
I love PHP and would really like to be able to use it for this project rather than JSP or ASP on IIS.
If anyone knows why this is crashing the server, I'd greatly appreciate any advice or help.
By the way, this is an enterprise-wide database so switching to MySQL is not an option.
View Complete Forum Thread with Replies
Related Forum Messages:
Ms Sql Serveur 2000 On Windows 2000 !!!
I've an error with php & win 2000 & ms sql serveur 2000! listen, i've write an program with win xp easyphp1.7 and ms sql serveur 2000 all is ok on localhost ! all i use some store procedures , triggers and so on all will be ok on local ! Code:
View Replies !
Windows 2000 Problems
when I open IE and enter in "http://localhost" I get: "The page cannot be displayed The page you are looking for is currently unavailable. The Web site might be experiencing technical difficulties, or you may need to adjust your browser settings." blah blah blah.... Then, when I click the Personal Web Manager icon in the Admin tools, I get this error: "Error connecting to servernamehere: Unexpected error 0x80074002 occurred. Do you wish to continue to attempt to connect to it in the future?"
View Replies !
PHP On IIS Windows 2000 Server
I've downloaded the latest PHP (EXE & ZIP).... I followed all the instructions I can find and yet PHP will not work with my IIS !! Can anyone talk me though exactly how to get them working together?
View Replies !
Installing On Windows 2000 Iis 5
for some odd reason the installer program doesn't set the file extension ..php to be associated with anything, my guess is that it should be php-win.exe (i've tried all 3 .exe files, and the php.exe produces the correct results in a command window)... when running a .php in IE I can see it execute in task manager but the IE screen will not change to display the correct info.. anyone have any idea about this? IE settings wrong or something?
View Replies !
Use Gettext In Windows 2000
How can i use gettext in windows 2000. problem in compile .po file. how can i make the .po file. tell me in detail step by step. also unable to find msgfmt.exe, libiconv.dll, libintl.dll to compile .po file in windows.
View Replies !
EGroupWare - With Windows 2000 Install
using Apache, PHP and MySQL on my own PC - been using it for a while on ISP hosted servers and plesk to create oline forums using things like Invision and PHPBB but decided to give running eGroupWare a go on my own PC. I have windows 2000 Pro and followed some online tutorial to the letter (excpet downloaded the very latest version of MySQl, PHP, etc) to install Apache, PHP and MySQL and all worked fine. Now downloaded eGroupWare and put it in the c:web folder and ran the setup file but when I go to my browser and tpye: http://localhost/egroupware/login.php I get the following below can anyone point me in the direction of what it all means?? Warning: main(C:/php/phpgwapi/setup/setup.inc.php): failed to open stream: No such file or directory in c:webegroupwareheader.inc.php on line 102 Warning: main(): Failed opening 'C:/php/phpgwapi/setup/setup.inc.php' for inclusion (include_path='.;c:php4pear') in c:webegroupwareheader.inc.php on line 102 Warning: main(C:/php/phpgwapi/inc/functions.inc.php): failed to open stream: No such file or directory in c:webegroupwareheader.inc.php on line 110 Warning: main(): Failed opening 'C:/php/phpgwapi/inc/functions.inc.php' for inclusion (include_path='.;c:php4pear') in c:webegroupwareheader.inc.php on line 110 Warning: main(C:/php/phpgwapi/inc/xml_functions.inc.php): failed to open stream: No such file or directory in c:webegroupwareheader.inc.php on line 111 Warning: main(): Failed opening 'C:/php/phpgwapi/inc/xml_functions.inc.php' for inclusion (include_path='.;c:php4pear') in c:webegroupwareheader.inc.php on line 111 Warning: main(C:/php/phpgwapi/inc/soap_functions.inc.php): failed to open stream: No such file or directory in c:webegroupwareheader.inc.php on line 112 Warning: main(): Failed opening 'C:/php/phpgwapi/inc/soap_functions.inc.php' for inclusion (include_path='.;c:php4pear') in c:webegroupwareheader.inc.php on line 112 Fatal error: Call to undefined function: createobject() in c:webegroupwarelogin.php on line 26
View Replies !
PHP5 Installation With MySQL, Windows 2000
Why I still have "undefined function error" messages? I included path c:php to my windows env. Edited php.ini file: include directory value. removed comment mark from extension=php_mysql.dll copied libmysql.dll to system32 directory Apache2 runs fine. I can run phpinfo.php I can create a database into the MySQL.
View Replies !
Include PEAR DB Framework Using PHP 5.0.4 On Windows 2000
Get the following errors when trying to include PEAR DB framework using PHP 5.0.4 on Windows 2000 with Apache 2. Warning: main(PEAR-1.3.3/DB/DB.php) [function.main]: failed to open stream: No such file or directory in E:Program FilesApache GroupApache2htdocsservusincludesinclude.php on line 19 Fatal error: main() [function.require]: Failed opening required 'PEAR-1.3.3/DB/DB.php' (include_path='.includes;.') in E:Program FilesApache GroupApache2htdocsservusincludesinclude.php on line 19 The include_path config variable looks like this: include_path = ".includes;." PHP is installed in e:php-5.0.4 and the PEAR Class defs are in e:php-5.0.4includesPEAR-1.3.3DBDB.php The includes that fail are: include_once("PEAR-1.3.3/DB/DB.php"); These worked with 4.4.0, but fail with 5.0.4 ...
View Replies !
UPDATE Command Is Not Working On MySQL, Windows 2000 Server
Hi all, I encountered mysterious problem with MySQL and PHP. UPDATE command is not working on MySQL configured on Apache 2 with Windows 2000 Server. It pulled my hairs for atleast 5 hours. MySQL says Affected rows: 0 (Query took ~ sec) always? Now, I've decided to move all PHP files and db to remote server. Can anyone suggest possible reasons for above errors?
View Replies !
Php Setup On Win 2000 IIS
php setup on win 2000 IIS how is it done, i've try but the pages dont show up . any one know of a step by step setup tutrioal on this please. I have phpMyAdmin 2.3.3 and My SQL.
View Replies !
Window 2000 & PHP.ini Set-up
I know i have to change some of the settings in the php.in file, can anyone tell me how to configure this file. At the moment the PHP works but does not save any session cookies. I only use the machine for web development. Spec : - Windows 2000 - PHP 4.2.3
View Replies !
MS-SQL Server 2000
i have a huge database that is mantained and updated on a daily basis. It is on a MS-SQL 2000 server. I need that data to be exported, preferably by a php script using a cron job every morning, to a MySQL database if anything has changed. I can write the code to do the SQL stuff and maipulate the data, but i'm confused as hell as how to connect to a MS-SQL server using either windows or linux (preferably linux) in order to GET the data! php's documentation of MS-SQL functions is very "lacking".
View Replies !
Upgrading Php On WIN 2000 Advanced
I am currently using php 4.04 on a WIN 2000 advanced server and I want to upgrade. I downloaded the win32 4.3 installer and think its just a matter of running the installer to complete the process. Is there anything else I need to configure (besides the php.ini) to keep my existing scripts running correctly? I am running multiple sites on one domain so I don't want to screw up the upgrade and cause any downtime.
View Replies !
Can't Output To Excel 2000
I can't seem to get Excel 2000 to translate an html page. I have Excel 97 perform the same task without a problem, but 2000 just diplays a series of broken image icons. This the code that I am using to connect to Excel- Header("Content-Disposition: inline; filename=myfile.xls"); Header("Content-Description: PHP4 Generated Data"); Header("Content-type: application/vnd.ms-excel; name='MIMS_Excel'"); flush; Is it a coding issue or a setting on Excel that I don't know about, or is it simply impossible.
View Replies !
Number Of Days In 1/1/2000
I am looking for a script that can report the number of days since 2000. It should handle leap years but I am not worried about accuracy to the hour/minute or seconds. I am writing a calendar program and need a reference point to base all my dates from. So I picked 1/1/2000.
View Replies !
5 / SQL Server 2000 Problem
I just setup my server with IIS6, PHP5, and all that's working great. Now I'm trying to install SQL Server 2000, and I'm running into one particular problem. When I add the extension in php.ini for php_mssql.dll, then try to connect to to the database i created for it... all it does is sit there looping forever "waiting for "servername""..... I installed client network unitlity, created alias with IIS virtual directory..
View Replies !
MS Access 2000 Pagination
I am using an MS Access 2000 database with PHP, via ODBC. I would like to create the navigation links "last, prev, next, last" from a retrieved data recordset. I have managed to do this with MySQL using the "LIMIT" clause in the SQL statement, but Access does not seem to support that. It seems to me that one can oly retrieve the top n or bottom n records, but not something in the middle.
View Replies !
Install PHP On Microsoft 2000 Professional
how to install PHP onto my computer. It uses microsoft 2000 professional. I have downloaded one of the later versions of the source code from php.net, but I'm having trouble configuring it. I tried the automatic installer, but I think it needs to be done manually.
View Replies !
PHP With ADO Stored Procedures In SQL Server 2000
here is the problem.. When this procedure runs I am supposed to get 2 output parameters. When an insert statement is going to generate duplicate names I get 1 for @checker and 3 for @insertid. When the Insert statement runs properly I am supposed to get 2 for @checker and an actual identity for @insertid. When using the code below, the part where the insert statement is unsuccessful works just as desired, however the part where it inserts the record returns zeros for both parameters. When the stored procedure is run using query analyzer it performs correctly in both instances. Here is my PHP code $cmd = new COM("ADODB.Command", NULL, CP_UTF8); $cmd->CommandText = "STP_insertartist"; $cmd->CommandType = 4; $cmd->ActiveConnection = $conn; $par=$cmd->Parameters; $par->Append($cmd->CreateParameter("@firstname",200,1,50,$_POST["txtfname"])); $par->Append($cmd->CreateParameter("@lastname",200,1,50,$_POST["txtlname"])); $par->Append($cmd->CreateParameter("@livedate1",3,1,9,$begdate)); $par->Append($cmd->CreateParameter("@livedate2",3,1,9,$enddate)); $par->Append($cmd->CreateParameter("@style",200,1,300,$_POST["txtstyle"])); $par->Append($cmd->CreateParameter("@datedescription",200,1,75,$datetext)); $par->Append($cmd->CreateParameter("@insertid",3,2,4)); $par->Append($cmd->CreateParameter("@checker",3,2,4)); $rec=$cmd->Execute; $invid=$cmd->Parameters["@insertid"]->Value; $check=$cmd->Parameters["@checker"]->Value; echo("Check: ".$check." Invid: ".$invid);.........
View Replies !
Problems With PDO And MSSQL (SQLserver 2000)
I have to fix a error within one of our php sites which accesses several identical MSSQL 2000 databases. The php-script is able to access some of these databases and can retrieve data out of the tables. But on some databases it only can connect but does not get any data from these databases. Of course I checked the connects and that there is data in the databases. This is all ok. I assume know that I have to change some settings at the MSSQL databases which are not working properly. Does someone know which prerequisites are required on MSSQL side to interact correctly with PHP via pdo ?
View Replies !
MySql Permission Problems (Win 2000)
I screwed up the permissions on my database. Basically I revoked all the permissions of the root account on the mysql table. To try to fix this, I went through all of the instructions here: http://dev.mysql.com/doc/refman/5.0...ermissions.html running: mysqld-nt.exe --defaults-file="C:Program FilesMySQLMySQL Server 5.0my.ini" --init-file=C:mysql-init.txt except in the mysql-init.txt file I put this: GRANT ALL ON mysql.* TO root
View Replies !
ODBC Query Of Access 2000 Db Using LIKE
Attempting to query MS Access database with the ODBC drivers for PHP. When using the LIKE statement no records are returned. Example: $query = " Select * From Dispatch Where Customer Like '*A*' "; $result = odbc_prepare($db,$query); odbc_execute($result); Does anyone out there know the syntax that I should be using for the Like statement in the Where clause? When I do a normal query, it works fine....Just using wildcards it does not work....
View Replies !
Problem Running PHP Script On 2000 Server
I am a web designer, and to process a form I placed a PHP script in it. The script sends input to an e-mail and writes it to a comma-delimited file as well. Well, I tested it on a Linux server and it works fine. However, when the IT guys placed it on a Windows 2000 server, the form does not process. I got this message from IT: "I tried installing Apache Webserver for windows and it displays the script on the screen when submitted but does not run the form. Rick, Is there anyway you can convert PHP -> ASP?" Code:
View Replies !
Insert Html / Pdf Into "image" Column In MSSQL 2000
I am trying to insert uploaded files into a M$ SQL 2000 database. The uploaded files are validated as either PDF or HTML and then passed to the database. They need to be stored in an image column so that they can be indexed for fulltext searching. Currently I get the following error when inserting the files into the db - "Operand type clash: text is incompatible with image" The files are read into a buffer and then they are prepared for the insert. I have tried both addslashes() and replacing a "'" (single quote) with "''" (two single quotes). I have seen suggestions that the data should be base64encode()'ed but can't get anything to work consistantly.
View Replies !
CLI And Windows
The portion of the PHP manual entitled "Using PHP from the command line" states that "The CGI SAPI supports the CLI SAPI behaviour by means of the -C switch when run from the command line.": http://us2.php.net/features.commandline However, "php -h" says of the -C switch, "Do not chdir to the script's directory". Further, running php -Cr "echo 'test'" results in an error saying that the -r switch doesn't exist, even though it should if it were acting like the CLI version. This, coupled with the fact that the Windows installer doesn't seem to install a seperate CLI exe means that, unless I'm missing something, CLI isn't something that can be used on Windows, contrary to what the docs say.
View Replies !
Php On Windows
I try to install PHP on Win 95 platform using Windows PHP installer, but it does't work. When running php.exe, I got error message "php.exe file is linked to missing export kernel32.dll: cancello." Where is wrong? Is it due to php not support win 95?
View Replies !
Pop-up Windows
I have a form coded as: <form action="test.php" method="post"> the form has two buttons: Preview and Submit if ($Preview) {// perform action 1} else {// perform action2} My question: If Preview is clicked, I would like to open a new pop-up window without closing the original one. I would like the results of action 1 to be displayed on this new pop-up window. Is there a way to do that without using javascript? If no, then how would you do that with javascript? i cannot use target=_blank in the form tag because i would like to have the pop-up window only if Preview is selected. But maybe there is a better way to code everything!
View Replies !
PHP On Windows XP Using IIS
I am trying to request form elements from a form from a page that looks like this: <html> <head> <title>Untitled Document</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> <form action="result.php" method="post"> Name: <input type="text" name="username" value="brenda"><br /> Email: <input type="text" name="email" value="hipples"><br /> <input type="submit" name="submit" value="Submit me!"> </form> </body> </html> Here is the results page, using multiple methods of variable retreival and it will not work locally but up on the web server it works fine.... <html> <head> <title>Untitled Document</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> <?php // Available since PHP 4.1.0 echo $_POST['username']; echo $_REQUEST['username']; import_request_variables('p', 'p_'); echo $p_username; // Available since PHP 3. As of PHP 5.0.0, these long predefined // variables can be disabled with the register_long_arrays directive. echo $HTTP_POST_VARS['username']; // Available if the PHP directive register_globals = on. As of // PHP 4.2.0 the default value of register_globals = off. // Using/relying on this method is not preferred. echo $username; ?> </body> </html> When I view the source of the result.php page, the opening <HTML> is never there, leading me to beleive that there is a header issue of some sort.
View Replies !
PHP And Windows CMD.exe ?
I'd like to somehow manage to get php sending things to windows cmd.exe. Is thier any possible way for example. I have to run a program to register a user, and I need to knwo if php is even capable of speaking with it. C:Documents and SettingsUSERDesktopSOMEFOLDER eleasesystem>addlicense.exe -a42790 8484 -psomepassword -ysomeuser -zsomepassword -l4 -b0 this is an example of what Im sending.
View Replies !
PHP Under Windows
I read somewhere that you need to install a virtual server (or something like that) if you want to run PHP scripts on a PC. The background is that I'd like to make the pages of my site dynamic, but would like to be able to view the site offline on my computer. Is there such a piece of software, possibly easy to install? I'm not too familiar with servers.
View Replies !
Windows API
Is it possible to open a named pipe from a php script on Windows? More specifically, I have a Windows service that receives commands through a named pipe, and I'd like to open the client end of the pipe directly from php rather than creating an intermediate process.
View Replies !
Windows CE
I try to interact with my php/MySQL data-input website via my PocketPC. Usually, no problem (other than having to do a lot of scrolling on pages never meant to fit in a 240 X 290 window). I recently built a fairly complex input form page that works just fine with a regular computer/browser. but when I submit (POST) form data using the PocketPC (using Pocket Internet Explorer) the data does not seem to post. nothing is saved and the script that receives it looks like it never saw any data arrive.
View Replies !
On Windows
Are there any disadvantages to running PHP on a Windows server as a CGI executable as opposed to running it on a Linux server?
View Replies !
PHP 5 And Windows XP
I have downloaded the binary zip file onto my desktop and am attempting to install it. I have created a folder in my Program Files called PHP into which I want to extract the files. From this point on I appear to be stuck as the files do not appear to want to extract to c:Program FilesPHP. Can anyone help me?
View Replies !
PHP, IIS On Windows
I installed IIS 5.1 and PHP 4.3.9 (windows installer version), apparently configures itself for use with IIS if the option is selected. Now when I drop a PHP file in C:Inetpubwwwroot and open in browser nothing happens just a blank page, it seems the PHP is not being intepreted. Does anyone have a quick list of settings for PHP and IIS on Windpows XP or any known issues so I can check through and hopefully sort it out cos it's driving me crazy!
View Replies !
PHP On Windows And Mysql
Is it possible to run php scripts on windows XP Professional with IIS? How? If yes, is it possible to access mysql database on windows by PHP? Is there any different between on windows and on linux?
View Replies !
Sockets On Windows
Hey all. I was going through the sockets tutorial and I am painstakingly trying to make windows xp allow me to play around with them but it wont let me. On my Linux box everything works fine, but windows is denying my socket connections except at the usual telnet port (23). Does anyone know how to configure port permissions, etc on windows xp?
View Replies !
Windows Sockets (yes I Know Its Old)
sorry to dig back into all this stuff but im having problems with sockets in a win98 env. my PHP is the installer version and i just added the .dll from the .zip after. what is happening is that im following the tutorial and have taken the server.php script at the end of part two and run it i then fire up telnet then connect to 127.0.0.1 (which i specified in the server.php file). then as soon as i type in a key i get a message "connection to host lost" and then in the DOS window where i am running PHP, it quits bqck to the DOS command prompt. any ideas guys?
View Replies !
Printing Under Windows
I'm wondering whether anyone knows of a good tutorial on how to use the PHP Printer Functions under Windows. I've been dabbling in it a little, but the PHP Manual is kinda flakey on the subject. I want to be able to print a report, generated in PHP, on the printer connected to the web-server (it's for an Intranet app).
View Replies !
Can't Get Variables Under Windows!!
I used PHP alot under linux but that's my first time to programme PHP under windows. However, I'm experiencing the weird case here. My php scripts can't get any variables from HTML form. not even by http://blahblah.com/phpscript.php?var1=hello.
View Replies !
|
TRACKER
