Can't get ODBC connection string to work with defined constants

[Eiolon]

I have a config file that has connection info for an ODBC connection:

 

define("MSSQL_HOSTNAME", "IP_HERE");
define("MSSQL_DATABASE", "DB_HERE");
define("MSSQL_USERNAME", "USER_HERE");
define("MSSQL_PASSWORD", "PASS_HERE");

 

My connection string is (taken directly from PHP.net manual):

 

<?php

require_once('config.php');

$connect_mssql = odbc_connect("Driver={SQL Server};Server=MSSQL_HOSTNAME;Database=MSSQL_DATABASE;", MSSQL_USERNAME, MSSQL_PASSWORD);

?>

 

If I change from using to defined constants to variables the connection works. 

 

For example:

 

$MSSQL_HOSTNAME = "IP_HERE");
$MSSQL_DATABASE = "DB_HERE");
$MSSQL_USERNAME = "USER_HERE");
$MSSQL_PASSWORD = "PASS_HERE");

 

<?php

require_once('config.php');

$connect_mssql = odbc_connect("Driver={SQL Server};Server=$MSSQL_HOSTNAME;Database=$MSSQL_DATABASE;", $MSSQL_USERNAME, $MSSQL_PASSWORD);

?>

 

Any ideas?

[trq]

Constants do not interpolate within a string.

[Eiolon]

Oh, I see.  I used concatentation and it appears to be working now