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 the
upshot was that my (large, data and CPU-intensive) program ran portably
on both Win2K and Linux. The mxODBC solution will cost money, but not
a lot (and MAL has done a great job letting you discover things about
the far end of the ODBC connection -- development is simple). The
switch between databases was really minimal effort on my part -- the
sysadmin who had to create and backup the DBs was not as sanguine about the changes. Check with Marc-Andre about the current state of the art
for linux ODBC drivers.
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?
This is also easy, and you can simply design a little socket watcher to get commands, execute them, and return results.
Thank you
-- http://mail.python.org/mailman/listinfo/python-list
