[PHP] php4 - MS SQL7 connection problem

2001-02-01 Thread Martin Tiscornia

Hello!
I'm running: WinNT4, IIS4, php 4.03pl1, and I'm trying to connect to MS SQL
7.
Well, I configured the php.ini (extension=php_mssql70.dll), and I copy that
.dll to the windows folder. Now I want to connect to the SQL and it doesn't
work, it makes a time out. If I do the same things with php 3.0.17 it works
fine.
The code:

   !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
   html
   headtitleUntitled/title/head
   body
   ?php
   $HOST = "the host";
   $USER = "the username";
   $PSW = "the password";
   $DB = "Database name";
   if (mssql_connect($HOST, $USER, $PSW))
 {
 mssql_select_db($DB);
 echo mssql_result( mssql_query("SELECT @@VERSION"), 0, 0);
 }
   if (!mssql_close())
 echo "No lo pudo cerrar";
   ?
   /body
   /html

Any solution?
Thank you in advance . . .


  - @n Angel -
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




RE: [PHP] php4 - MS SQL7 connection problem

2001-02-01 Thread Jason Bouwmeester

Not sure if this helps but when I used PHP and SQL 7 I used odbc set of
commands, not mmssql commands (i.e. odbc_pconnect and odbc_close etc).

HTH,
Jason

-Original Message-
From: Martin Tiscornia [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 01, 2001 10:27 AM
To: [EMAIL PROTECTED]
Subject: [PHP] php4 - MS SQL7 connection problem


Hello!
I'm running: WinNT4, IIS4, php 4.03pl1, and I'm trying to connect to MS SQL
7.
Well, I configured the php.ini (extension=php_mssql70.dll), and I copy that
.dll to the windows folder. Now I want to connect to the SQL and it doesn't
work, it makes a time out. If I do the same things with php 3.0.17 it works
fine.
The code:

   !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
   html
   headtitleUntitled/title/head
   body
   ?php
   $HOST = "the host";
   $USER = "the username";
   $PSW = "the password";
   $DB = "Database name";
   if (mssql_connect($HOST, $USER, $PSW))
 {
 mssql_select_db($DB);
 echo mssql_result( mssql_query("SELECT @@VERSION"), 0, 0);
 }
   if (!mssql_close())
 echo "No lo pudo cerrar";
   ?
   /body
   /html

Any solution?
Thank you in advance . . .


  - @n Angel -
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]