ID:          41887
 Updated by:  [EMAIL PROTECTED]
 Reported By: mark dot vanrossum at bris dot ac dot uk
-Status:      Open
+Status:      Bogus
 Bug Type:    Documentation problem
 PHP Version: Irrelevant
 New Comment:

It is probably caused by bug #42046.


Previous Comments:
------------------------------------------------------------------------

[2007-07-03 12:44:57] mark dot vanrossum at bris dot ac dot uk

Description:
------------
I was pulling my hair out getting the error:
  "stored procedure execution failed"
when trying to run mssql_execute but could run:
  $results = mssql_query('sp_test'); 
fine.

I was connecting using the string:
  $dbserver="xxx.xxx.xxx.xxx:1433";
  $cn = mssql_connect($dbserver, $dbuser, $dbpass);

where xxx is the IP address.

It seems that this doesn't work, you need to do the following:
edit your freetds.conf file and add the connection in here, eg:
[YourServer]
        host =xxx.xxx.xxx.xxx
        port = 1433
        tds version = 8.0

Then try and connect as:
$cn = mssql_connect('YourServer', $dbuser, $dbpass);

This could be made clearer in the docs.  I've added this as a note as
well.  There are a couple of bug reported about this, which if the docs
were clearer wouldn't get reported hopefully.



------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=41887&edit=1

Reply via email to