PHP & MSSQL

[Deks]

Hello,

 

am having problem with connection to mssql server and database. Am using Xampp and i think there is some problem about his configuration.

All the time am getting error : missing driver php_mssql.dll in xampp/php/ext/  ....and file php_mssql.dll is there (same problem with php_pdo_mssql.dll).

Also am getting this error: "Fatal error: Call to undefined function mssql_connect() "

I tried everything i could find on forums, blogs, and php documentation...but always same.

 

btw... i removed ";"  in php.ini from necessary lines and i copy ntwdblib.dll in necessary folders.

This is my connection code:

   $dbHost = 'Workstation:<port>';
   $dbUser = 'user';
   $dbPass = 'pass';
   $dbName = 'database';
$con = mssql_connect ($dbHost, $dbUser, $dbPass) or die ('MsSQL connect failed. ' . mssql_error());
mssql_select_db($dbName) or die('Cannot select database. ' . mssql_error());

 

I also tried with:

$connection = odbc_connect("Driver={SQL Server Native Client 10.0};Server=$server;Database=$database;", $user, $password);

but always same....

 

 

Can anybody please provide me some working solution ?

 

 

Thanks.

 

 

[Adam]

Did you restart Apache after you removed the semi-colon?

[criostage]

Every single configuration you do to apache (even if you add or remove a dot) in the config you MUST restart the apache service on your computer otherwise your apache server wont assume the new settings.

[Deks]

ofc i did restart, not just apache..i restarted pc also.

 

Like i told i did everything in my knowledge i collected from forums, blogs, and php documentation.