We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Running Python Script as External Procedure in Vertica 7.1 — Vertica Forum

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 ?

 

Regards

Vini

Leave a Comment

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