error odbc-snowflake-php-84 layer #581

Activity

1. AngularProUser

   closed this as completedon Apr 7, 2025
2. AngularProUser

   reopened this on Apr 7, 2025
3. AngularProUser commented on Apr 7, 2025

   

   AngularProUser

   on Apr 7, 2025

   Author

   More actions

   Hi,

   Please error still occur using theses versions :
   "bref/bref": "2.4.1"
   "bref/extra-php-extensions": "1.7.1", "1.7.2"
4. lracicot commented on May 21, 2025

   

   lracicot

   on May 21, 2025

   Last edited by lracicot

   More actions

   We have the same problem. I don't know if it is related to the same underlying cause as mkleehammer/pyodbc#738 (comment). provided.al2 uses a glibc 2.26 and it comes with unixODBC 2.3.1. Snowflake does not seem to document which version of the driver they require so maybe there is something to confirm there... 🤔

   Broken
   ${bref-extra:odbc-snowflake-php-82}
   "bref/bref": "2.4.4"
   "bref/extra-php-extensions": "1.8.3"

   Works
   ${bref-extra:odbc-snowflake-php-82}
   "bref/bref": "2.4.4"
   "bref/extra-php-extensions": "1.2.6"

   If we compare the versions between 1.2.6 and 1.7.0 (from @AngularProUser ) the only line that changed in the snowflake layer is this one: https://github.com/brefphp/extra-php-extensions/compare/1.2.6..1.7.0#diff-cf2ca12bf4226b1c5481b7b70ae7e4fa20860d39affc2ef7ee0138697797bd77R21
5. AngularProUser commented on Jun 20, 2025

   

   AngularProUser

   on Jun 20, 2025

   Author

   More actions

   I manually built and deployed an ODBC-Snowflake layer using the Dockerfile from:

   https://github.com/brefphp/extra-php-extensions/blob/master/layers/odbc-snowflake/Dockerfile

   I configured the following variables:

   PHP_VERSION = 84
   BREF_VERSION = 2
   Using the Snowflake ODBC driver version 2.25.12 (downloaded from https://sfc-repo.snowflakecomputing.com/odbc/linux/2.25.12/snowflake_linux_x8664_odbc-2.25.12.tgz), everything works without errors.

   However, when using a newer Snowflake ODBC driver (3.X.X, downloaded from https://sfc-repo.snowflakecomputing.com/odbc/linux/3.X.X/snowflake_linux_x8664_odbc-3.X.X.tgz), I encounter the following error on odbc_connect():

   odbc_connect(): SQL error: [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed, SQL state IM004 in SQLConnect