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