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

[Joseph K. <jko...@ma...>]

On 2004-11-02 15:37:47 -0700, Ian Bicking <ia...@co...> said:

> 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.

I didn't. Everything I tried was either ODBC based, or psycopg type 
da's. SQLRelay looks promising though.

> 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.

I haven't tried those either as I was looking for something that would 
work for *nix.

Joseph