francisl wrote:
We have to build some script were I work to make a dynamic server inventory.
But, the project team, a windows crew, start it all in vbscript and on mssql. Note, due to political reason, we can not use mysql or anyother one that are not *authorize*, it's oracle or mssql. Now we have to make it work also with our sun and HP unix server(plus one Linux).
So I propose to use python, and after they see my litle python/wxwindow program, that list windows registry value relate to SUS automatic update and that let it remotely force a check. They were amaze on how short it took to make us save a lot of time. - Windows by default put a static value in its LastWaitTimeout key, in their doc they said 48 hrs. But 48 hrs is to long for a good schedule on production server. Plus it give us headaches to validate all the update on our network. (~75 winnt/2k/2k3 servers)
back to subject
Question.
Can we, directly from unix select and insert data in a remote mssql database?
if not, my second though was to put a litle python server on the server holding the mssql database, which will accept request and insert it in the database. But is that possible?
Thank you
If ODBC access is permissible then you could, for example, use mxODBC on top of one of the generic ODBC drivers for Unix.
Since Oracle is also an "approved" database you might also want to think about using the cxOracle module, which AFAIK is available on both Windows and Unix-like platforms.
There are several ways you could have remote Python processes talking to each other. Pyro is a package that would let you handle this situation relatively easily, and I'm sure others will chime in with their favored solutions.
regards Steve -- Steve Holden http://www.holdenweb.com/ Python Web Programming http://pydish.holdenweb.com/ Holden Web LLC +1 703 861 4237 +1 800 494 3119 -- http://mail.python.org/mailman/listinfo/python-list
