I created a DB client for an MS SQL client and then used the wizard to generate the form. When I first ran the code (in localhost mode), I got the message "Please make sure MSSQL extension is loaded in php.ini".

So I installed the PHP library provided by Microsoft (php_sqlsrv_53_ts.dll) but then got a message saying it was unable to initialize becuase the module APIs did not match.

Anyone know where to get the correct SQL module?

Update: I changed the DLL to php_sqlsrv_54_ts.dll since the local server uses PHP 5.4.

Now I get the orginal message "Please make sure MSSQL extension is loaded in php.ini"

I changed the generated config file from $config['db'] = 'mssql' to $config['db'] = 'sqlsrv' and then got the message "Document Contains no data." yet I know there are records in the table.

Any suggestions?

Thanks

Did you sort it in the end? I have a similar problem I think. Thanks