MSSQL 2008 , ODBC, sqlsrv ... no good solution |
[eluser]kkristo[/eluser]
Hi I have bad problem. Client final server is IIS7 and MSSQL database. From linux server I can access MSSQL server database (remote). But, from MS IIS server I have lot problem. PHP 5.3 not have mssql driver. when I try connect ODBC, then CI 2 do wrong sql str. Example. $this->db->get('dbo.text')->result_array(); CI do select * from (`dbo.test`) , and MSSQL don't eat this string. MSSQL 2008 like select * from dbo.test OK, I can always use $this->db->query('select * from blahh'), but, this seems wrong. PHP 5.2.x have sqlsrv driver, but CI2 don't have driver. PHP 5.3 don't like sqlsrv driver (I don't know why but not load extension) . One strange problem more. If I try connect ODBC , System DSN, PHP 5.3 don't see ODBC odbc_connect('systemdsn_name', '', '') . Maybe this my bad and need give IIS <--> ODBC extra permission? Server is Windows Web Server 2008.
[eluser]kkristo[/eluser]
case close. 1 full day and PHP reinstall help: sqlserv driver ver 2.0 extension start working. And http://www.phrenzy.org/code/sql-server-and-php/ CI driver work too. (CI 2.0) |
Welcome Guest, Not a member yet? Register Sign In |