php_mssql.dll vs php_sqlsrv.dll

Talk about working with different database types

Moderators: ne_moj, zewa, vadimako, ne_moj, zewa, vadimako

ldhansen
Newbie
Newbie
Posts: 6
Joined: Oct 20th, '10, 04:21

php_mssql.dll vs php_sqlsrv.dll

Postby ldhansen » Mar 23rd, '11, 12:18

For PHP version 5.3+, php_mssql.dll no longer works. Will PHP DataGrid work with the new php_sqlsrv.dll?

administrator
Site Admin
Site Admin
Posts: 5992
Joined: Jan 7th, '09, 23:18
Contact:

Re: php_mssql.dll vs php_sqlsrv.dll

Postby administrator » Mar 24th, '11, 13:57

No answer still, we'll check this. Thanks. Generally, it must work.
Can you check it also by yourself?

ldhansen
Newbie
Newbie
Posts: 6
Joined: Oct 20th, '10, 04:21

Re: php_mssql.dll vs php_sqlsrv.dll

Postby ldhansen » Mar 25th, '11, 07:48

Well, when I try I get:
Fatal error: Call to undefined function mssql_connect()

Which I'm sure is because the php_mssql.dll no longer exists in PHP 5.3+ and so cannot be loaded in the php.ini file. I am loading the new replacement extensions:

extension=php_sqlsrv_53_nts_vc9.dll
extension=php_pdo_sqlsrv_53_nts_vc9.dll

but there are differences in the php_sqlsrv API. So me thinks php_sqlsrv needs to treated as a new database type in the DataGrid. For now I can get by with using ODBC to work with MS SQL Server, but long term, it would be nice if Datagrid would support PHP 5.3+ and SQL Server. I will gladly upgrade when it does. :D

administrator
Site Admin
Site Admin
Posts: 5992
Joined: Jan 7th, '09, 23:18
Contact:

Re: php_mssql.dll vs php_sqlsrv.dll

Postby administrator » Mar 27th, '11, 11:55

DataGrid works with PEAR and unfortunately developing of this library was stopped.
You may try to re-write mssql PEAR driver to suite your needs.


Return to “Databases: different types implementation”