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

Babelfish and the SQLSRV driver in PHP


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

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