Running Python Script as External Procedure in Vertica 7.1

Hi ,


We have a python script that connects to database using pyodbc.connect and processes some sql statements.

When we run the script from shell - ./<script_name>.py , it runs perfectly fine. But when I install the script inside Vertica Database and create an external procedure and try to execute it as select <proc_nam>();, it fails with error could not connect to DSN.


What could be the possible cause for the same ?




Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file