[sqlalchemy] Re: Trouble inserting Binary into MSSQL DB's

2008-09-19 Thread Michael Bayer
On Sep 19, 2008, at 3:25 AM, [EMAIL PROTECTED] wrote: I am having a problem inserting binary data into an existing MS DB. A very simple example is like this class FooTable: __tablename__ = 'mytable' keycol = Column(String(15), nullable=False, primary_key=True) bincol =

[sqlalchemy] Re: Trouble inserting Binary into MSSQL DB's

2008-09-19 Thread Rick Morrison
There's no doubt that pyodbc is the better-supported option; the pymssql module hasn't been updated in two years, and it relies on the Microsoft DB lib, which has been deprecated for a long, long time and is no longer supported, and may not even work with MSSQL 2008. Here's the deprecation notice

[sqlalchemy] Re: Trouble inserting Binary into MSSQL DB's

2008-09-19 Thread Sam Widmer
Thanks for the responses so far. The reason we tried pymssql is because it is much easier to get running on OSX. At the moment our efforts to get pyodbc working on Macs have met with alot of frustration. However, we would have done things differently if we had seen different wording in the

[sqlalchemy] Re: Trouble inserting Binary into MSSQL DB's

2008-09-19 Thread Michael Bayer
On Sep 19, 2008, at 1:24 PM, Sam Widmer wrote: Thanks for the responses so far. The reason we tried pymssql is because it is much easier to get running on OSX. At the moment our efforts to get pyodbc working on Macs have met with alot of frustration. However, we would have done