Michael Bayer wrote:
> Kent Johnson wrote:
>> I added a simple MSUnicode type to mssql.py, basically copying what was
>> done for MSString and changing String to Unicode, varchar to nvarchar.
>> Is this a reasonable fix? Why is NVARCHAR not supported in the
>> distribution?
>
> thats entirely reasonable; in fact we have an ongoing "more types needed!"
> thing with pretty much all the database implementations. the various
> database modules seem to start with the core set of useful types before
> people go through the effort to exhaustively implement all of them, thats
> all.
OK, I uploaded a patch to Trac with this change.
>
>> If I define the Table columns myself it seems to work, I can do a simple
>> select at least. So this is not a showstopper but it would be nice if
>> the autoload worked. Here is the connection string I use:
>>
>> db = create_engine('mssql://cbowner:[EMAIL PROTECTED]/CurriculumBuilder')
>>
>> I would be interested in general comments about the state of MS SQL
>> support in SQLAlchemy; is it pretty solid or is it still gelling?
>
> While I am very rigorous about the "big three" open-source databases (at
> least those that run on my powerbook: sqlite, postgres, mysql), and i also
> maintain most of the oracle module, the MS-SQL and firebird modules were
> contributed by other SA enthusiasts and have been worked on by at least
> half a dozen people. its only recently that I actually got MS-SQL
> installed on a windows box but i usually dont have the resources to
> actually fire it up and track down issues; I have gotten basic MS-SQL
> reflection to work via the pymssql module but i havent installed adodbapi.
> i wonder if its something related to the ado module ? it might be
> interesting if you could see if thats the case for your particular test
> program (or if you could post a full test program to a new trac ticket).
>
> we're generally in need of a little more help with testing/debugging the
> MS-SQL module.
I might be able to give a little help. I would like to see it working
but I don't know how much I can contribute. It's a little tricky because
I am trying to learn SA and fix it at the same time...
Kent
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
