#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2000
    Location
    Cape Town, South Africa
    Posts
    0
    Rep Power
    0
    Someone help please!
    I would like to port data to MS SQL with Python. Does someone know how to do that? I've checked MySQL etc, and got a product called mxODBC that could talk to MS Access, but that seems to be rather clumsy. I would like to work directly with MS SQL via ODBC from Python. Now who has done this before?
    I would really appreciate it if someone can shed some light on this matter.
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2004
    Posts
    1
    Rep Power
    0
    You don't need mxODBC. All you need are the win32 extensions for python installed.
    http://starship.python.net/crew/mham...Downloads.html

    Here is an example of how to use them:http://www.python.org/windows/win32/odbc.html

    Of course this will only work on windows. There should be an equivalent for Unix, anyone else want to comment on that? Also, I realize there are some ODBC classes for wxWidgets, but I never got them to work in python.

    good luck,
    Matt
  4. #3
  5. Banned ;)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Nov 2001
    Location
    Woodland Hills, Los Angeles County, California, USA
    Posts
    9,648
    Rep Power
    4248
    You can also use ADO
    Up the Irons
    What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home.
    "Death Before Dishonour, my Friends!!" - Bruce D ickinson, Iron Maiden Aug 20, 2005 @ OzzFest
    Down with Sharon Osbourne

    "I wouldn't hire a butcher to fix my car. I also wouldn't hire a marketing firm to build my website." - Nilpo
  6. #4
  7. Hello World :)
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Mar 2003
    Location
    Hull, UK
    Posts
    2,537
    Rep Power
    69
    Hey scropy, do you still have the link to your article on ADO? Wouldn't mind reading though it again.

    Mark.
    programming language development: www.netytan.com Hula

  8. #5
  9. Banned ;)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Nov 2001
    Location
    Woodland Hills, Los Angeles County, California, USA
    Posts
    9,648
    Rep Power
    4248
    Heh, my webhost is having trouble and my website is down. I do have a mirror running from home, but you'll need to edit your hosts file to get to it. Please PM me for instructions, if you want to read the article now, or wait a few days till they resolve the problem. .
    Up the Irons
    What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home.
    "Death Before Dishonour, my Friends!!" - Bruce D ickinson, Iron Maiden Aug 20, 2005 @ OzzFest
    Down with Sharon Osbourne

    "I wouldn't hire a butcher to fix my car. I also wouldn't hire a marketing firm to build my website." - Nilpo
  10. #6
  11. Banned ;)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Nov 2001
    Location
    Woodland Hills, Los Angeles County, California, USA
    Posts
    9,648
    Rep Power
    4248
    All right! My webhost just resolved their issues. If you're interested, my ADO and python article is here:
    http://www.mayukhbose.com/python/ado/index.php
    Up the Irons
    What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home.
    "Death Before Dishonour, my Friends!!" - Bruce D ickinson, Iron Maiden Aug 20, 2005 @ OzzFest
    Down with Sharon Osbourne

    "I wouldn't hire a butcher to fix my car. I also wouldn't hire a marketing firm to build my website." - Nilpo
  12. #7
  13. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2004
    Posts
    10
    Rep Power
    0
    What's the most efficient way(cost and library indepence) to connect to mssql? Also, I'm trying to connect to the database on a solaris box. Is there a good way of doing this?

    Joe

IMN logo majestic logo threadwatch logo seochat tools logo