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
|
