subprocess & isql

Discussion in 'Python' started by peterff66, Jul 15, 2011.

  1. peterff66

    peterff66 Guest

    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.
     
    peterff66, Jul 15, 2011
    #1
    1. Advertising

  2. peterff66

    sturlamolden Guest

    On 15 Jul, 04:47, "peterff66" <> wrote:

    > 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.
     
    sturlamolden, Jul 15, 2011
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Nishi Bhonsle
    Replies:
    2
    Views:
    23,599
    pahujadeepanshu
    Nov 30, 2009
  2. Sigfried Manner

    Linux / how to check if subprocess is still alive

    Sigfried Manner, Sep 1, 2003, in forum: C Programming
    Replies:
    7
    Views:
    804
    Irrwahn Grausewitz
    Sep 1, 2003
  3. Remi Morin
    Replies:
    0
    Views:
    517
    Remi Morin
    Oct 23, 2006
  4. hiral
    Replies:
    2
    Views:
    605
    Jean-Michel Pichavant
    May 5, 2010
  5. mike

    isql in perl

    mike, Dec 26, 2003, in forum: Perl Misc
    Replies:
    10
    Views:
    947
    Keith Keller
    Dec 29, 2003
Loading...

Share This Page