Hallo,
after reading about removing sqlite2 and mssql, I was thinking about some problems with database-connections via pdo
on windows.
Pdo_mssql isn't included in the windows binaries anymore. Pdo_dblib is meant for non MS-Plattforms.
Pdo_odbc doesn't work as replacement on Windows.
Reason: SQL-Statements working untouched with pdo_mysql, pdo_sqlite, pdo_oci, pdo_pgsql and pdo_mssql
won't work with pdo_odbc (ODBC is complaining about datatype mismatches where aren't any)
On the other hand pdo_oracle can't handle resultsets with a CLOB in each row...
After all, there is one question left: Is it advisably building a multi-database-application with pdo in the moment?
Kind regards,
Daniel
hi,
after reading about removing sqlite2 and mssql, I was thinking about some problems with database-connections via pdo
on windows.
The only question was about sqlite2. mssql is not going to be removed.
Pdo_mssql isn't included in the windows binaries anymore. Pdo_dblib is meant for non MS-Plattforms.
Pdo_odbc doesn't work as replacement on Windows.
Please consider to use SqlSrv on Windows:
http://www.microsoft.com/sqlserver/2005/en/us/PHP-Driver.aspx
It is well supported and the 2.0 version comes with PDO support as well.
Cheers,
Pierre
@pierrejoye | http://blog.thepimp.net | http://www.libgd.org