search

sqitchers / docker-sqitch

Docker Image packaging for Sqitch
MIT License
35 stars 39 forks source link

DBD::ODBC 1.59 required to manage Snowflake #26

Closed mdhatrika closed 4 years ago

mdhatrika commented 4 years ago

Hi, I am planning to integrate sqitch as part of the CICD Pipeline, for this to happen I want to first set the sqitch locally to connect to snowflake. As part of the prerequisites, I use these 2 documents

To download the odbc driver for snowflake I followed this document and made setup and was able to connect to the snowflake successfully and following is the version it shows SQL> select current_client(); CURRENT_CLIENT() | ODBC 2.21.3 https://support.snowflake.net/s/article/How-to-create-Snowflake-ODBC-DSN-On-MacOS Downloaded and installed the snowsql using this document and was able to connect to snowflake succesfully https://docs.snowflake.com/en/user-guide/snowsql-install-config.html#installing-snowsql-on-macos-using-the-installer For sqitch I refred to this document https://sqitch.org/docs/manual/sqitchtutorial-snowflake/ So the problem is when I try to do sqitch deploy I am getting this error DBD::ODBC 1.59 required to manage Snowflake sqitch deploy 'db:snowflake://account_name/DBname?Driver=SnowflakeDSIIDriver' I tried including the username and password in the above URI but still getting the same error. Please help me to figure out what I am doing wrong. Thanks

theory commented 4 years ago

You also need to install DBD::ODBC. I don’t know how you installed Perl and all the Sqitch dependencies, but you’ll need to install DBD::ODBC such that it can find the ODBC libraries when it builds.

mdhatrika commented 4 years ago

after I install the DBD:: ODBC and DBI it is working now. Thank you so much :)

binbenban commented 3 years ago

after I install the DBD:: ODBC and DBI it is working now. Thank you so much :)

could you please share the steps to install these? Thanks!

jimdobson-act3 commented 3 years ago

@mdhatrika, I'm experiencing the same problem, would be very helpful if you would share the steps to install. Thank you!

rubenslj00 commented 3 years ago

I need help on how to install DBD::ODBC 1.59 , and how to configure it please