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@xxxxxxxxxxx
________________________________________
From: Elizabeth M Smith [auroraeosrose@xxxxxxxxx]
Sent: Tuesday, June 17, 2008 3:58 PM
To: php-windows@xxxxxxxxxxxxx
Subject: 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 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:
>
> <html>
> <head>
> <title>PHP Test</title>
> </head>
> <body>
> <?php
> echo "<p>Hello!</p>";
> $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);
> ?>
> </body>
> </html>
>
> 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@xxxxxxxxxxx
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
