Hi,
If you remove the @ in front of the mssql_* functions you might get a bit
more information about the problem.
Using the MSSQL Server extension requires these stapes:
1) Install the SQL Server Client tools on the maschine running PHP (if
your are using Win32)
2) Configure a server alias using the client network utility. The alias
specifies name, host name, protocol and port numbers used for the db
communication.
3) Connect to the database using the alias as db name as first parameter
in mssql_connect.
4) If the SQL Server is configured for trusted connections only, enable
this in PHP.INI by setting mssql.secure_connection = On (no need for
userid and password then)
If you are connection from a *nix box. You need to compile and install
FreeTDS and recompile php using the --with-mssql configure option.
There is no need to create any ODBC configurations to use the mssql_*
functions
- Frank
> I'm in the process of learning PHP. I've gotten to the point of having
> problems with accessing a database. What is happening is that I am
getting
> the message "Couldn't connect to SQL Server on BOBOS" (the name of the
> server). I've tried putting in a user but with the same results. Now,
I'm
> wondering if there is some setting in the php.ini file that I missed.
I
> specified in the php.ini file to use the sql server extension and it
> compiles without error. Here is the code.
>
> <?php
> $myServer = "BOBOS";
> $myUser = "Bobo the Bugbear";
> $myPass = ""; //password not required
> $myDB = "picture_DB";
>
> $server = @mssql_connect($myServer, $myUser, $myPass)
> or die("Couldn't connect to SQL Server on $myServer");
>
> $database = @mssql_select_db($myDB)
> or die("Couldn't open database $myDB");
>
> $result = mssql_query("SELECT * FROM category",$database);
> printf ("Category: %s<br>n", mssql_result($result,0,"name"));
> while($row = mssql_fetch_row($result))
>
> {
> echo "<li>" . $row[0] . "</li>";
> }
> ?>
>
> What might I be missing? I already specified the database in the ODBC
> connection part of windows. Wasn't sure if this was needed or not but
did
> it anyway. Anyway, if you could send me a note on what it is I might
be
> missing, I would greatly appreciate it.
>
> thanks
>
>
>
> --
> 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
