[Long query fails sql server 2000]

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 

 

[Long query fails sql server 2000]

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

 

[Linked server can't read more that 20 fields]

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

[Query runs on Query Analizer but not trough php code]

forgot some details, running SQL Server 2000 and XAMPP 1.7.3 both on Windows server 2003

[Query runs on Query Analizer but not trough php code]

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

');

 

[Query runs on Query Analizer but not trough php code]

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....

[HOW TO PUT MY SERVER ON THE WEB?]

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...