Re: [SQLObject] Re: DBConnection for MS SQL Server / MSDE

[Ian B. <ia...@co...>]

Joseph Kocherhans wrote:
> On 2004-11-01 14:05:17 -0700, Ian Bicking <ia...@co...> said:
> 
>> Sean M. Hester wrote:
>>
>>> I checked the archives for "SQL Server" and "SQLServer" but didn't find
>>> anything--my apologies if I'm needlessly rehashing an old topic.
>>> Anyway...has anyone already worked on providing DBConnection 
>>> compatibility
>>> with MS's SQL Server 2K or MSDE? If so, would you care to share? If 
>>> not, are
>>> other parties interested if I wind up going down the rabbit hole?
>>
>>
>> There's some code in 
>> svn://colorstudy.com/home/jkocherhans/SQLObject-mssql-branch , I 
>> haven't looked at it at all, so I don't know more.
> 
> 
> That branch uses mxODBC, so it *does* require some non-free software. I 
> was never able to find another stable way to connect to SQL Server from 
> python. 

Did you try SQLRelay (sqlrelay.sf.net)?  I haven't tried it, but it 
seems like a possible solution.  I think I also saw something recently 
(on PyPI?) that used a similar client-server setup, where you put some 
sort of simple server on the Windows box, and then there's a client that 
implements the DB API.

If you're on Windows natively, I guess there's another odbc 
implementation in win32all, and there's a DB API driver that runs off of 
ADO, which I think you can use through COM.

But I've never actually tried any of these.

-- 
Ian Bicking  /  ia...@co...  /  http://blog.ianbicking.org