'Connecting to an MSSQL database through ODBC Error

Where to start..

  • I have a server with windows 2008 R2 standard 32 bits.
  • On that server ISS 7 is installed and a php site is added but requires databases.
  • Made an sql database on that server wich is called 'test'.
  • ODBC connection is made and tested and it succeeded.

  • Now when I use this php code to connect to the server it gives me:

    Can not connect because the target machine actively refused it.

php code:

<?
### Database    ###
$user = "*****"; //database user
$pass = "*****";    //database password
$host = "localhost";   //database location
$db = "test";     //database name
##mysql_connect ("$host","$user","$pass");
##mysql_select_db("$db");
$dbConn = odbc_connect("$db","$user","$pass","$host") or die(odbc_errormsg());
?>

The password and username are correct but the error still remains.

Any help is appreciated!

phpiis-7odbc


Solution 1:[1]

Have you set your datasource using administrative tools, data sources, System DSN?

if not i'm sure it won't find the database.

see this link: http://support.microsoft.com/kb/305599

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Liam Sorsby

Related Questions