subprocess & isql

[peterff66]

Hello Python community,

I am working on a project that retrieves data from remote Sybase. I have touse isql and subprocess to do this. Is the following correct?

1. call subprocess.popn to run isql, connect to Sybase
2. run sql ("select ...from ...")
3. write retrieved data to subprocess.pipe
4. retrieve data from pipe

Did anybody do similar work before? Any ideas (or code piece) to share?

Thanks so much.

 

[sturlamolden]

I am working on a project that retrieves data from remote Sybase. I have to use isql and subprocess to do this. Is the following correct?

I once had to hammer a nail, but I had to use a screw driver. Didn't
work.

Did anybody do similar work before? Any ideas (or code piece) to share?

Nobody has ever used Python to connect with an SQL database before.
There is no Python database API, and no Sybase module.