how can I connect to MS SQL Server 2005?

[eluser]cwt137[/eluser]
Hello,

Your first problem is that it is trying to connect to mysql. Put this code in to change the driver to mssql:

Code:

$db['default']['dbdriver'] = "mssql";

Also, you need the mssql PHP extension installed. You can check phpinfo() to see if you have it installed. If you don't have it installed and you are running Fedora/RHEL/Centos, look for either the php-extras or the php-mssql rpm package in the regular repo. or the EPEL repo. Else, look in your distro's repository or compile it in. If you don't want to do all that work set up a DSN and use ODBC.