Skip to main content

Hi all,

  • June 21, 2021
  • 4 replies
  • 2 views

janpeter.van.d
Level 12
Forum|alt.badge.img+26

Hi all,

 

I would like to install the Python library 'pyodbc' in order to extract data from a database using a custom database driver. However, I get errors when I try it to install via PIP. I found out that this could be caused when the ODBC header files are not installed (link). To do this, a sudo command is neccessary which requires admin login credentials for the jovyan environment. Since these are not shared, can somebody help me to solve this?

Thanks in advance!

 

Cheers,

Jan-peter

4 replies

  • Level 0
  • November 29, 2021

Hi Jan-Peter,

 

I was searching internally if there were some topics related to admin login credentials for the jovyan environment but I could not find anything. In this case I would recommend reaching out to our ServiceDesk so your request can be routed to the appropriate backend engineer.

 

Best

Kevin


gabriel.okaba11
Celonaut
Forum|alt.badge.img+2

Hi Jan,

Even if someone shared the credentials, once the workbench restarted, you would need to do sudo again.

As a suggestion, you can use your own environment locally. This way you could install the libraries.

 

Best,

Gabriel


janpeter.van.d
Level 12
Forum|alt.badge.img+26
  • Author
  • Level 12
  • November 30, 2021

Hi @kevin.flesc and @gabriel.okaba11,

 

Thanks for you time to look for solutions. We successfully created an initial data pipeline using a local environment indeed, and working now with the Celoxtractor method to make it more user friendly.

 

Kind regards,

Jan-peter


janpeter.van.d
Level 12
Forum|alt.badge.img+26
  • Author
  • Level 12
  • November 30, 2021

Hi Jan,

Even if someone shared the credentials, once the workbench restarted, you would need to do sudo again.

As a suggestion, you can use your own environment locally. This way you could install the libraries.

 

Best,

Gabriel

I would love to select this answer as best, but unfortunately the buttons are not visible.