I'm not 100% sure what you are trying to do, but I'm wondering if there are better ways to connect to MSSQL from Linux:

Randy Syring
Development | Executive Director
Direct: 502.276.0459
Office: 502.212.9913

Level 12
            Technologies
Principled People | Technology that Works

On 04/08/2013 01:57 AM, Vernon D. Cole wrote:
Dear Gurus:

I have committed to the django community that I would provide a prototype remote adodbapi function -- so that django running on Linux will be able to open a MS SQL Server database. This work, if successful, may be expected to result in SQL Server support becoming part of mainstream django. The major modifications to adodbapi to support this are complete: you can now use keyword arguments (like user= and host=) in your .connect() call and have them inserted into your connection string.

I am trying to create a remote api connection using PyRO to communicate with a server utility on Windows.  I can actually execute a simple query now.

It occurred to me this morning that using PyRO to emulate remote COM calls may not be the smartest design.  Perhaps I should be using DCOM -- that is what DCOM was designed for after all.  A quick check shows that there are a number of Linux DCOM implementations out there, from both the WINE and SAMBA communities, and even a commercial version.  Let me start by saying that I know absolutely nothing about DCOM, including the level of DCOM support in pywin32.  (I did not know much about PyRO either, before last week.)

So I am asking advice on which way to jump:
1) stick with PyRO all the way.
2) drop the PyRO effort immediately and start using DCOM.
3) go ahead and finish a basic remote client using PyRO, but plan on re-doing it in DCOM for full functionality.
???
Vernon



_______________________________________________
python-win32 mailing list
python-win32@python.org
http://mail.python.org/mailman/listinfo/python-win32


_______________________________________________
python-win32 mailing list
python-win32@python.org
http://mail.python.org/mailman/listinfo/python-win32

Reply via email to