Hi, Greg:
i have went back to the conf file I have in the freetds directory to edit the server information to
# A typical Microsoft server
[egServer70]
host = 192.168.10.128
port = 1433
tds version = 7.2
Since I am using MS SQL 2005, I thought I would have to change this to tds version 7.2 instead of 7.0.
I have edited the MSSQL connection to as follows:
//connection to the database
$dbhandle = mssql_connect($myServer, $myUser, $myPass)
or die("Couldn't connect to SQL Server on $myServer");
//select a database to work with
$selected = mssql_select_db($myDB, $dbhandle)
or die("Couldn't open database $myDB");
Since I could not find the exact syntax for this on http://www.php.net, I have modified it as you suggested. The error message that says couldn't connect to the server was brought back a lot quicker than before, but I still could not connect it.
Are there other packages I have to install?
Thanks for your help.
Alice
======================================================
Alice Wei
MIS 2009
School of Library and Information Science
Indiana University Bloomington
ajwei@xxxxxxxxxxx
________________________________________
From: Greg Maruszeczka [listmail@xxxxxxxxxx]
Sent: Friday, June 13, 2008 10:51 AM
To: php-general@xxxxxxxxxxxxx
Subject: Re: PHP Runs But Does NOT Connect to MSSQL Server
On Fri, 13 Jun 2008 10:32:22 -0400
"Wei, Alice J." <ajwei@xxxxxxxxxxx> wrote:
> Hi, Greg:
>
> I have just run the command
>
> [root@localhost php-5.2.6]# php -m | grep mssql
> mssql
>
> It appears that my RPM is fully installed. I could ping to the
> machine, but I could not connect to it. I have set the TCP to 1433,
> and UDP to 1434. Therefore, even though my syntax
>
> $dbhandle= mssql_connect($myServer, $myUser, $myPass)
>
> appears to be accurate with the proper password, ip, and username
> defined prior to this, I only get "PHP Warning: mssql_connect():
> Unable to connect to server: 192.168.10.128
> in /usr/local/apache/htdocs/test.php on line 22" Could there be
> something that I have missed?
>
Alice
Perhaps. Check the documentation for myssql_connect and be sure that
you're not supposed to also provide a port number (in your case 1433)
along with the hostname argument. IIRC you can tag it after the
hostname/ip using a colon (e.g. myhostname:1433).
Other than that it seems more like a network connectivity issue. This
is OT for this list but if it was my problem I'd ensure there aren't
any packet filters between my web server and db hosts. Since MSSql has
to run on windows I'd start there and ensure inbound connects to TCP
1433 are allowed. You're using private address space (192.168.x.x). Are
BOTH servers on the same subnet?
GM
--
Greg Maruszeczka
http://websagesolutions.com
skype: websage.ca
googletalk: gmarus
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
