Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Problem with ms sql functions

Author  Topic 

chensaadia
Starting Member

1 Post

Posted - 2014-09-28 : 18:37:57
I'm new to ms sql server, i'm using php 5..3 and i have connected between the php to my sql server.
My connection code look like this:

$serverName = "server_name";
$connectionInfo = array( "Database"=>"myDB" , "UID"=>"myid", "PWD"=>"mypassword");
$conn = sqlsrv_connect($serverName, $connectionInfo);
if($conn == false){ // cant connect to the server
die( print_r( sqlsrv_errors(), true));
}
else{

}
And it works fine.
The problem is when im trying to use one of the mssql functions like mssql_select_db, mssql_query or mssql_init. When i try to run the php with one of the functions it fails.
I have tried all of the code in http://php.net/manual/en/function.mssql-execute.php and nothing works.
Does anyone know what the problem is and how to solve it?
   

- Advertisement -