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