MSSQL - Connection takes for ever to connect vs. ASP

rdawson

I love PHP, but I am forced to us MS products at work. As such we have a dedicated MS SQL Server 2000 box that i must work with. I have a database that i connect to using the following PHP code:

$server = "Server IP,PORT";
$user_name = "server username";
$password = "pass";
$database = "dbname";

if(!($sql_connect =mssql_connect($server,$user_name,$password)))
die ("Could not connect to:<b> $server</b>");

mssql_select_db($database) or DIE("database:$database is not unavailable");
//end//

which actually gets me connected, but it takes for ever to run even the simplest query. However, when i do the same query in ASP the connection flys. The server the script is on is hosted on a IIS box and I am using the ISAPI filter for IIS and I run PHP 4.2. I have all of the MS SQL server files installed on the dedicated box from the CD.

again the connection works but takes forever to connect. I have tried the connection above as well as an ODBC connection, and it still takes twice as long as ASP.

Is there any way to speed things up?

Thanks,

ayzee

yup,

but it involves a petrol can, a box of matches and a replacement linux box running mySQL and Apache.

In all seriousness, this is a problem that I am currently looking into as I have the same problem.

I'll post when I sort it.

ChaosDream

well, I just got a load of exensions for php 4.* including the php_mssql.dll file, and i get an error saying

"unable to load dynamic link library 'php_mssql.dll' - the specified module could not be found."

do you know what to do about it?

rdawson

Thanks ayzee,

LOL sounds painfull. I will continue my quest as well, but keep me posted on what you find out.

Thanks again,

coellen

Originally posted by ChaosDream
well, I just got a load of exensions for php 4.* including the php_mssql.dll file, and i get an error saying

do you know what to do about it?

Can you please check Your network libraries (SQL Server Client Network Utility). As mentioned in an other thread I have this problem too with TCP/IP-DBMSSOCN.DLL 7.0.819.
On an other server it runs well with DBNETLIB.DLL 8.0.194

Both are MSSQL 7.0 Servers...

Thanks
Niels

ChaosDream

my dbnetlib.dll is version 2000.80.194.0
and my dbsoccn.dll is version 1999.10.20.0

how do i (not ? ) use them ?

larus_spuni_is

Im using similar platform:
PHP-CGI Version 4.2.3 ,IIS (Windows NT 5.0), MS SQL Server 2000 and the ADOdb database abstraction library.

This actually works using the php_mssql.dll installed in the c:\winnt\system32 directory. I get connection to the database without problems.

My application is rather big but executes amazingly fast on this platform unless when searching the database. Geting data by key is very fast but I time out on the search. Then if the same query is posted again the data returns very fast (probaly do to seme caching mechanism in the SQL server).

This same code worked fine with MS SQL Server 7 with some older version of PHP.

Has anyone experienced degraded performance after upgrading to MS SQL Server 2000?

will post the solution if I find it.

Thanks
Lárus.

Sxooter

Have you tried connecting with ODBC? I get pretty good performance against Squeal Server with ODBC, never tried the TDS drivers since ODBC seemed pretty fast to start with.

ChaosDream

you can use ODB with sql server 2000? how?

something like this?:
odbc_connect("server","user","pass") or die ("unable to connect");
odbc_select_db("db") or die ("unable to select db");

(Im just guessing, but dont you need another dll file for that? (call me stupid if you want to... 🙂 ))

[edit]
eek! I got a response!

Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in D:\Website_php\2.php on line 21
unable to connect

[/edit]