# Database-Connectivity

- Thread: https://externals.io/message/48810
- Original archive: https://news-web.php.net/php.internals/48810
- Started by Daniel Henning on 2010-06-16T19:56:43+00:00
- Messages: 6
- Reply by email to internals@lists.php.net
- More for agents: search with https://externals.io/search.md?q={query} · JSON API at https://externals.io/api · documentation at https://externals.io/llms.txt

---

## #48810 — Daniel Henning — 2010-06-16T19:56:43+00:00

URL: https://externals.io/message/48810#48810

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

---

## #48811 — Pierre Joye — 2010-06-16T20:08:10+00:00

URL: https://externals.io/message/48810#48811 · In reply to: #48810

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

---

## #48812 — Daniel Henning — 2010-06-16T21:13:10+00:00

URL: https://externals.io/message/48810#48812

hi,

>The only 
>question was about sqlite2. mssql is not going to be removed.

The question came up in the mails about sqlite2. I was thinking about pdo in general.

>Please consider to use SqlSrv on Windows
>It is well supported and the 2.0 version comes with PDO support as well.

If version 2 will have one - great.

Now only the problems around pdo_oci needs to be handled.

Kind regards,
Daniel

---

## #48813 — Pierre Joye — 2010-06-16T21:27:01+00:00

URL: https://externals.io/message/48810#48813 · In reply to: #48812

> hi,
>
> > […]
>
> The question came up in the mails about sqlite2. I was thinking about pdo in general.
>
> > […]
>
> If version 2 will have one - great.
>
> Now only the problems around pdo_oci needs to be handled.


Did you open a bug report for the CLOB and resultset issue? (if that's a bug)

Cheers,
-- 
Pierre

@pierrejoye | http://blog.thepimp.net | http://www.libgd.org

---

## #48814 — Daniel Henning — 2010-06-17T04:20:06+00:00

URL: https://externals.io/message/48810#48814

Hi,

>Did you open a bug report
>for the CLOB and resultset issue? (if that's a bug)

http://bugs.php.net/bug.php?id=44589

Kind regards,
Daniel

---

## #48815 — Derick Rethans — 2010-06-17T09:22:06+00:00

URL: https://externals.io/message/48810#48815 · In reply to: #48813

> 
> > […]
> 
> Did you open a bug report for the CLOB and resultset issue? (if that's a bug)

I did; years ago: http://bugs.php.net/bug.php?id=44852

regards,
Derick

-- 
http://derickrethans.nl | http://xdebug.org
Like Xdebug? Consider a donation: http://xdebug.org/donate.php
twitter: @derickr and @xdebug