DaniWeb Forum Index > Web Development > PHP

PHP-MSSQL Connectivity

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jul 2009

Posts: 1

Reputation: rojanjcb is an unknown quantity at this point

Solved Threads: 0

rojanjcb

Offline

Newbie Poster

PHP-MSSQL Connectivity

Jul 23rd, 2009

do anyone knows how to connect to a MS SQL server(database in internet,i have ip,db username and db password).i used mssql_connect from my PHP ,but how to activate it in windows or Ubutu.i download all dll files needed but i cant connect..pls help me....

•

Join Date: Jul 2008

Posts: 39

Reputation: emiola is an unknown quantity at this point

Solved Threads: 1

emiola

Offline

Light Poster

Re: PHP-MSSQL Connectivity

Jul 23rd, 2009

How do you mean in Windows? It will be better understood if you will expantiaite on "activate it in windows or Ubutu". Do you want to connect to your database from your windows operating system such that you will be able to export/import data?
If yes, let the forum know.
Thank you.

O God! He that teaches man what he knows not, please grant us the solution.

•

Join Date: Jul 2009

Posts: 2

Reputation: tlore22 is an unknown quantity at this point

Solved Threads: 0

tlore22

Offline

Newbie Poster

Re: PHP-MSSQL Connectivity

Jul 23rd, 2009

Have you checked that you have the latest ntwdblib.dll( this has solved my connection problem)? You should paste this dll over your dll's from apache and php(I think it can be found in two places). Restart apache
then use mssql_connect like this:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$myServer = "xx.xx.xx.xx";
$myUser = "sa";
$myPass = "yyyyyyyyyyyyy";
$myDB = "zzzzzzzzzzz";
 
//connection to the database
$dbhandle = mssql_connect($myServer, $myUser, $myPass)
  or die("Couldn't connect to SQL Server on $myServer");
 
//select a database to work with
$selected = mssql_select_db($myDB, $dbhandle)
  or die("Couldn't open database $myDB");
$myServer = "xx.xx.xx.xx";
$myUser = "sa";
$myPass = "yyyyyyyyyyyyy";
$myDB = "zzzzzzzzzzz";

//connection to the database
$dbhandle = mssql_connect($myServer, $myUser, $myPass)
  or die("Couldn't connect to SQL Server on $myServer");

//select a database to work with
$selected = mssql_select_db($myDB, $dbhandle)
  or die("Couldn't open database $myDB");

If it still does not work you should try to connect to the database through MS SQL Management Studio.
If it does not connect talk to the owner of the database

Last edited by peter_budo; Jul 24th, 2009 at 3:26 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.