Database.php settings for MSSQL database

[eluser]JamesD[/eluser]
[quote author="cblosser" date="1197782028"]Yes,

I've looked at all of that. It only gives an example of a mysql connection. I'm just not sure if i'm putting the right setting in the hostname for a mssql driver or odbc? Do I just put in local host, or do I need a full DSN there?[/quote]

If CI is located on the same server as the MSSQL database is, then I would think localhost would be the correct hostname.

Wouldn't the port number come into play if using DNS instead of localhost?

Disclaimer Note: Personally, I haven't messed with MSSQL too much.... so, I'm not 100% :cheese:

Here's another snippet from the guide (if it helps):
[quote author="CodeIgniter User Guide"]For information on each of these values please see the configuration page.

Or you can submit your database values as a Data Source Name. DSNs must have this prototype:
$dsn = 'dbdriver://username:password@hostname/database';

$this->load->database('$dsn');

Note that if you use a DSN you will not be able to specify some of the default values like you can if you use a connection array.[/quote]

Any avid MSSQL users out there that could shine some light?