Re: Python, unix and mssql

2004-12-23 Thread Peter Hansen
francisl wrote: Can we, directly from unix select and insert data in a remote mssql database? Sorry, I can't answer that one. 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 p

Re: Python, unix and mssql

2004-12-23 Thread Scott David Daniels
francisl wrote: Can we, directly from unix select and insert data in a remote mssql database? In some sense you can. I used python and mxODBC to talk ODBC protocol to DB2 / MS SqlServer / Access. It was quite a while ago, and I may have had to use an odbc-on-linux piece I don't know about. But

Re: Python, unix and mssql

2004-12-23 Thread Steve Holden
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 h