Skip to main content

Running Python Script as External Procedure in Vertica 7.1

  • September 2, 2015
  • 0 replies
  • 6 views

Aadu

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 ?

 

Regards

Vini