By using AWS re:Post, you agree to the Terms of Use

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.

asked 4 months ago17 views
1 Answer
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.
answered 4 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions