RE: [PHP] php4 - MS SQL7 connection problem
| From: | Jason Bouwmeester | Date: | Thu, 01 Feb 2001 17:28:56 +0000 |
| Subject: | RE: [PHP] php4 - MS SQL7 connection problem | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-37668@lists.php.net to get a copy of this message | ||
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:phpmatsound@hotmail.com]
Sent: Thursday, February 01, 2001 10:27 AM
To: php-general@lists.php.net
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>
<head><title>Untitled</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: php-general-unsubscribe@lists.php.net
For additional commands, e-mail: php-general-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net