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
preguntada hace 2 años253 visualizaciones
1 Respuesta
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
respondido hace 2 años

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas