PHP and MSSQL Connection on IIS 5.1

am 17.06.2008 17:58:44 von ajwei

Hi, Guys:

This is my first time running PHP 5.2 on a IIS 5.1 Server using a Windows=
XP machine.
My client wants me to build the PHP scripts and the database on one singl=
e machine. So far I could run the PHP fine, but I am having a hard time con=
necting to the MSSQL database even though it is on one machine.

I have created a freetds.conf file and have it set in the Windows directo=
ry in the following format:

[global]
host =3D 192.168.10.62
port =3D 1433
client charset =3D UTF-8
tds version =3D 8.0
text size =3D 20971520

I have then went into C:\Inetpub\wwwroot\test and built a index.php script,=
with my code as follows:

PHP Test

echo "

Hello!

";
$myServer =3D "global";
$myUser =3D "user";
$myPass =3D "password";
$myDB =3D "books";
// connection to the database
$dbhandle =3D mssql_connect($myServer, $myUser, $myPass)
or die("Couldn't connect to SQL Server on $myServer");
// select a database to work with
$selected =3D mssql_select_db($myDB, $dbhandle)
or die("Couldn't open database $myDB");
echo "You are connected to the " . $myDB . " database on the " . $myServer =
.. ".";
// close the connection
mssql_close($dbhandle);
?>

So far I only get this from the screen:

Hello!
Couldn't connect to SQL Server on global

Is there anything else I have missed? I have followed the prompts of instal=
ling FreeTDS according to http://docs.moodle.org/en/Installing_MSSQL_for_PH=
P, Would anyone say if I use something like ODBC would work better?

I welcome any suggestions.

Alice
==================== =====3D=
==================== =====3D=
====
Alice Wei
MIS 2009
School of Library and Information Science
Indiana University Bloomington
ajwei@indiana.edu

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: PHP and MSSQL Connection on IIS 5.1

am 17.06.2008 21:58:32 von Elizabeth M Smith

Wei, Alice J. wrote:
> Hi, Guys:
>
> This is my first time running PHP 5.2 on a IIS 5.1 Server using a Windows XP machine.
> My client wants me to build the PHP scripts and the database on one single machine. So far I could run the PHP fine, but I am having a hard time connecting to the MSSQL database even though it is on one machine.
>
> I have created a freetds.conf file and have it set in the Windows directory in the following format:
>
> [global]
> host = 192.168.10.62
> port = 1433
> client charset = UTF-8
> tds version = 8.0
> text size = 20971520
>
> I have then went into C:\Inetpub\wwwroot\test and built a index.php script, with my code as follows:
>
>
>
> PHP Test
>
>
> > echo "

Hello!

";
> $myServer = "global";
> $myUser = "user";
> $myPass = "password";
> $myDB = "books";
> // 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");
> echo "You are connected to the " . $myDB . " database on the " . $myServer . ".";
> // close the connection
> mssql_close($dbhandle);
> ?>
>
>
>
> So far I only get this from the screen:
>
> Hello!
> Couldn't connect to SQL Server on global
>
> Is there anything else I have missed? I have followed the prompts of installing FreeTDS according to http://docs.moodle.org/en/Installing_MSSQL_for_PHP, Would anyone say if I use something like ODBC would work better?
>
> I welcome any suggestions.
>
> Alice
> ======================================================
> Alice Wei
> MIS 2009
> School of Library and Information Science
> Indiana University Bloomington
> ajwei@indiana.edu

I've found that ODBC or PDO_ODBC works much better with Microsoft SQL if
PHP is on windows - the native client driver odbc connection string
works really well with MSSQL 2005 ;) Usually freetds is only needed if
you need to connect from a linux box with PHP to a windows box with mssql.

Thanks,
Elizabeth

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: Re: PHP and MSSQL Connection on IIS 5.1

am 17.06.2008 22:30:36 von ajwei

Hi,

For ODBC connections, are you using MSSQL 2005? I am currently using Wind=
ows XP for the server with PHP 5.2.

I am currently using this version of the MS SQL server, and thus when I =
am seting up the ODBC connection, I notice that it keeps failing possibly b=
ecause the SQL Server is indicated as 2000 and not even 2003. Would this ma=
ke a difference?

Thanks in advance.

Alice
==================== =====3D=
==================== =====3D=
====
Alice Wei
MIS 2009
School of Library and Information Science
Indiana University Bloomington
ajwei@indiana.edu
________________________________________
From: Elizabeth M Smith [auroraeosrose@gmail.com]
Sent: Tuesday, June 17, 2008 3:58 PM
To: php-windows@lists.php.net
Subject: [PHP-WIN] Re: PHP and MSSQL Connection on IIS 5.1

Wei, Alice J. wrote:
> Hi, Guys:
>
> This is my first time running PHP 5.2 on a IIS 5.1 Server using a Windo=
ws XP machine.
> My client wants me to build the PHP scripts and the database on one sin=
gle machine. So far I could run the PHP fine, but I am having a hard time c=
onnecting to the MSSQL database even though it is on one machine.
>
> I have created a freetds.conf file and have it set in the Windows direc=
tory in the following format:
>
> [global]
> host =3D 192.168.10.62
> port =3D 1433
> client charset =3D UTF-8
> tds version =3D 8.0
> text size =3D 20971520
>
> I have then went into C:\Inetpub\wwwroot\test and built a index.php scrip=
t, with my code as follows:
>
>
>
> PHP Test
>
>
> > echo "

Hello!

";
> $myServer =3D "global";
> $myUser =3D "user";
> $myPass =3D "password";
> $myDB =3D "books";
> // connection to the database
> $dbhandle =3D mssql_connect($myServer, $myUser, $myPass)
> or die("Couldn't connect to SQL Server on $myServer");
> // select a database to work with
> $selected =3D mssql_select_db($myDB, $dbhandle)
> or die("Couldn't open database $myDB");
> echo "You are connected to the " . $myDB . " database on the " . $myServe=
r . ".";
> // close the connection
> mssql_close($dbhandle);
> ?>
>
>
>
> So far I only get this from the screen:
>
> Hello!
> Couldn't connect to SQL Server on global
>
> Is there anything else I have missed? I have followed the prompts of inst=
alling FreeTDS according to http://docs.moodle.org/en/Installing_MSSQL_for_=
PHP, Would anyone say if I use something like ODBC would work better?
>
> I welcome any suggestions.
>
> Alice
> ==================== =====
==================== =====3D=
=====3D
> Alice Wei
> MIS 2009
> School of Library and Information Science
> Indiana University Bloomington
> ajwei@indiana.edu

I've found that ODBC or PDO_ODBC works much better with Microsoft SQL if
PHP is on windows - the native client driver odbc connection string
works really well with MSSQL 2005 ;) Usually freetds is only needed if
you need to connect from a linux box with PHP to a windows box with mssql.

Thanks,
Elizabeth

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Re: PHP and MSSQL Connection on IIS 5.1

am 17.06.2008 22:39:12 von Elizabeth M Smith

Wei, Alice J. wrote:
> Hi,
>
> For ODBC connections, are you using MSSQL 2005? I am currently using Windows XP for the server with PHP 5.2.
>
> I am currently using this version of the MS SQL server, and thus when I am seting up the ODBC connection, I notice that it keeps failing possibly because the SQL Server is indicated as 2000 and not even 2003. Would this make a difference?
>
> Thanks in advance.
>
> Alice
> ======================================================
> Alice Wei
> MIS 2009
> School of Library and Information Science
> Indiana University Bloomington
> ajwei@indiana.edu
> _____________________

As long as you're using the right odbc connection string it shouldn't
matter - you shouldn't have to use a dsn even -

www.connectionstrings.com/?carrier=sqlserver has a nice listing of how
you should be formatting your connection strings

Remember that you need to be able to have permission to connect to the
database! For PHP the easiest way to do this is to get TCP/IP working
for sqlserver and using sql level authentication, not windows
authentication. You'll have to get into the client tools to get this
working properly, and it's been long enough since I had to mess with it
that I don't remember exactly where those settings are.

Thanks,
Elizabeth

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: Re: PHP and MSSQL Connection on IIS 5.1

am 17.06.2008 23:00:48 von ajwei

Hi,

Thanks for the document. I have used the Administrative Tools to create a n=
ew ODBC data source, and it has been shown that the tests has been done suc=
cessfully from the System DSN.

My next question is this, with my ODBC driver compiled successfully, this =
is the connection string I have established to connect to the database usin=
g ODBC connection.

$connection_string =3D 'DRIVER=3D{SQL Server};SERVER=3Dlocalhost;DATABASE=
=3Dmaster';
$user =3D 'user';
$pass =3D 'xxxxx';
odbc_connect($connection_string, $user, $pass) or die ("Cannot connect to d=
atabase");
echo "You are connected to the database';

However, this has so far never given me any success. As I mentioned before,=
since this PHP script would be stored on the same server as the database, =
I only have to indicate the server as localhost, as I have had in the ODBC =
connection, right?

Or, is there anything else I have missed?
Thanks for your help.

Alice
==================== =====3D=
==================== =====3D=
====
Alice Wei
MIS 2009
School of Library and Information Science
Indiana University Bloomington
ajwei@indiana.edu
________________________________________
From: Elizabeth M Smith [auroraeosrose@shitennou.com]
Sent: Tuesday, June 17, 2008 4:39 PM
To: Wei, Alice J.
Cc: php-windows@lists.php.net
Subject: Re: [PHP-WIN] Re: PHP and MSSQL Connection on IIS 5.1

Wei, Alice J. wrote:
> Hi,
>
> For ODBC connections, are you using MSSQL 2005? I am currently using Wi=
ndows XP for the server with PHP 5.2.
>
> I am currently using this version of the MS SQL server, and thus when =
I am seting up the ODBC connection, I notice that it keeps failing possibly=
because the SQL Server is indicated as 2000 and not even 2003. Would this =
make a difference?
>
> Thanks in advance.
>
> Alice
> ==================== =====
==================== =====3D=
=====3D
> Alice Wei
> MIS 2009
> School of Library and Information Science
> Indiana University Bloomington
> ajwei@indiana.edu
> _____________________

As long as you're using the right odbc connection string it shouldn't
matter - you shouldn't have to use a dsn even -

www.connectionstrings.com/?carrier=3Dsqlserver has a nice listing of how
you should be formatting your connection strings

Remember that you need to be able to have permission to connect to the
database! For PHP the easiest way to do this is to get TCP/IP working
for sqlserver and using sql level authentication, not windows
authentication. You'll have to get into the client tools to get this
working properly, and it's been long enough since I had to mess with it
that I don't remember exactly where those settings are.

Thanks,
Elizabeth

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: Re: PHP and MSSQL Connection on IIS 5.1

am 17.06.2008 23:25:15 von ajwei