Connect to MS SQL Express 2008

[eluser]obiron2[/eluser]
Thanks guys,

I have finally worked it out with PHP natively (i.e. not via CI) and will post a full solution here are soon as I have fully tested it with CI.

There is an updated .dll that is required in the apache/bin folder and you need to change some of the default settings in SQLExpress to accept SQL logins as well as NTAUTHORISATION, plus allow named pipes and TCP/IP connections.

Oh - and don't forget to turn of IIS7 !!

currently I can't get it to use the database configuration and create a connection string that will return me a results set from a query (I seem to be connecting to the database as CI throws no errors, but the results set is empty)