1 Replies - 549 Views - Last Post: 08 October 2010 - 02:21 AM Rate Topic: -----

#1 Rhoda Rose  Icon User is offline

  • D.I.C Head

Reputation: -5
  • View blog
  • Posts: 93
  • Joined: 21-June 10

Connection from php to sql server 2005 database using sqlsrv_connect()

Posted 08 October 2010 - 01:00 AM

Good day!

After connecting my php to sql server 2005 using the mssql_connect() syntax, which did not work. I try my best that I can to work it, but at the end I could not fix the error. So now, I try another option like I used Microsoft Driver for SQL Server and the syntax that Iím using is sqlsrv_connect()


Here are some configurations that I do to work the connection

1. I put the php folder in in C:\
2. I configure my IIS 6.0 to run php using isapi
3. I installed the SQLSRV20.EXE inC:\php\ext
4. I configure my php.ini
I uncommented the ff:
extension_dir = "./ext"
cgi.force_redirect = 0
doc_root = "C:\Inetpub\wwwroot"
I add extension=php_sqlsrv_53_ts_vc9.dll


I create a php file to test the connection
<?php
$server = "ISM\SQLEXPRESS";
$connectOptions = array("Database" => "dbtest");
//Because UID and PWD are not specified in the connection option
//The connection is made with Windows Authentication.
if($conn)
{
echo "Connection established";
}
else
{
echo "Connection could not be established";
}
?>


After I run this code I got an error like this:

Fatal error: Call to undefined function sqlsrv_connect() in C:\Inetpub\wwwroot\testconn.php on line 5

I donít know where is the problem and how can I fix it.

I need to fix it as soon as possible, because almost 3 weeks I troubleshoot this connection.

Any help is highly appreciated
Thank you in advance.

Is This A Good Question/Topic? 0
  • +

Replies To: Connection from php to sql server 2005 database using sqlsrv_connect()

#2 no2pencil  Icon User is offline

  • Toubabo Koomi
  • member icon

Reputation: 5191
  • View blog
  • Posts: 26,899
  • Joined: 10-May 07

Re: Connection from php to sql server 2005 database using sqlsrv_connect()

Posted 08 October 2010 - 02:21 AM

Making multiple topics isn't going to get your question answered any faster. Stop it!

orignial topic.
Was This Post Helpful? 2
  • +
  • -

Page 1 of 1