Jump to content

Bennett

New Members
  • Posts

    7
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

Bennett's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Yes I've changed the mssql timeout on the ini, and restarted the apache, I checked the phpinfo and it all seems good, but nothing helps, and when I run the same script in sql analyzer it works fine
  2. Greetings, I have a problem when executing long sql querys, it gives me an error like this Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\consolidadora\tablas.php on line 9 I've tried to modify the timeout to -1 on both ini and via script, I've read that this problem has been around on new versions of apache and set_time_limit (30000) by the way I'm running: Windows 2003 server PHP Version 5.3.1 any ideas on how to overcome this issue? Please help I'm desperate, had this problem for a couple of days now and can't get around it
  3. Hello there, I have a problem which I previously posted about, the thing is that on php I can't get more that 20 fields transferred (read) at once, and on analyzer it works like a charm. I'm running windows server 2003, sql 2000 sp4, php 5.3.1 and Apache 2.2.14, the linked server is another sql 2000 with the same characteristics PLEASE HELP
  4. forgot some details, running SQL Server 2000 and XAMPP 1.7.3 both on Windows server 2003
  5. here are the general setting I use: mssql_query('set nocount off set arithabort on set concat_null_yields_null on set ansi_nulls on set cursor_close_on_commit off set ansi_null_dflt_on on set implicit_transactions off set ansi_padding on set ansi_warnings on set quoted_identifier on set parseonly off ');
  6. Greetings, I have a strange problem, that is that my query would run good on analyzer but id returns warning through PHP, here is the script: IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE' AND TABLE_NAME='cart082010') UPDATE a SET a.c_empresa=b.c_empresa,......... from cart082010 a, Sogfih_TOC.Sogfih_OPDF.dbo.cart082010 b WHERE a.c_empresa = b.c_empresa AND .......... ELSE SELECT * into cart082010 FROM Sogfih_TOC.Sogfih_OPDF.dbo.cart082010 please help....
  7. HELLO ANYONE, I'M VERY NEW TO THE SERVER ON WEB SUBYECT SO ANY HELP AT ALL WILL DO, THE THING IS THAT I HAVE WOS (WEBSERVER ON A STICK) COUSE I'M CONSTANTLY UPGRATING MY SITE AND I DON'T HAVE A STEADY IP BUT I NEED A WAY TO HOST MY OWN SERVER ON THE WEB, TO BE HONEST IT'S FOR NO SPECIAL REASON I JUST WANT TO KNOW HOW IT'S DONE, THANKS IN ADVANCE...
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.