[python-win32] Remote ado: should I use PyRO or DCOM?

[Randy Syring]

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:

  * http://www.microsoft.com/en-us/download/details.aspx?id=28160 (+ pyodbc)
  * pymssql (use HG tip or the very latest release, the project has been
    somewhat neglected but the premise is sound and we have a new
    contributor who has been driving the project forward)


*Randy Syring*
Development | Executive Director
Direct: 502.276.0459
Office: 502.212.9913
Level 12 Technologies <https://www.lev12.com/>
/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 at python.org
> http://mail.python.org/mailman/listinfo/python-win32

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-win32/attachments/20130408/59548b71/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Level-12-Logo-email-sigs.png
Type: image/png
Size: 4071 bytes
Desc: not available
URL: <http://mail.python.org/pipermail/python-win32/attachments/20130408/59548b71/attachment.png>