Babelfish and the SQLSRV driver in PHP

0

Is there support for PHP with Babelfish using the SQLSRV driver? It doesn't throw any error message but the $conn returns as FALSE. Tested with python3 pyodbc library and it works fine.

AWS
light
posta 2 anni fa253 visualizzazioni
1 Risposta
0

To support the driver, here is what needs to be done:

  • By default the driver expects MARS to be switched ON. Since Babelfish does not support MARS we return MARS OFF in the Pre-login response, this is not expected by the PHP driver hence it times out gracefully.
  • The workaround is to add “MultipleActiveResultSets=false” in the connection URL.
AWS
light
con risposta 2 anni fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande