The SA MSSQL module currently supports the three DBAPI modules mentioned
above (pyodbc, pymssql, adodbapi).
You'll need to either get one of those three to import under IronPython, or
add support for the IPCE adaptor.
On 6/20/07, d_henderson <[EMAIL PROTECTED]> wrote:
>
>
> I recently tried SA again, and found that IronPython can now import it
> without errors.
>
> I seem to be missing some critical bit when connecting the driver to
> SA
>
> I have IPCE-r6
>
> >ipy -V
> IronPython 1.1 (1.1) on .NET 2.0.50727.42
>
> My test program starts like so:
>
>
>
> import sys, os, os.path
> import dbapi
>
> import odbc as db
> dbapi._load_type(db.assembly,db.typename)
>
> sa_path = os.path.join(os.getenv('SA'), 'lib')
> sys.path.append(sa_path)
>
> from sqlalchemy import *
>
> DatabaseName = 'Temp'
>
> db = create_engine('mssql://DEVELOPERS-W2K3/'+DatabaseName)
>
>
>
> >ipy test_sa1.py
> Traceback (most recent call last):
> File D:\Software\IronPython\dbTest\test_sa1.py, line 15, in
> Initialize
> File __init__, line unknown, in create_engine
> File D:\Downloads\Python\SQLAlchemy-0.3.8\lib\sqlalchemy\engine
> \__init__.py, line 154, in create_engine
> File strategies, line unknown, in create
> File D:\Downloads\Python\SQLAlchemy-0.3.8\lib\sqlalchemy\engine
> \strategies.py, line 58, in create
> File D:\Downloads\Python\SQLAlchemy-0.3.8\lib\sqlalchemy\databases
> \mssql.py, line 350, in dbapi
> ImportError: No DBAPI module detected for MSSQL - please install
> pyodbc, pymssql, or adodbapi
>
>
> I am trying to use the DBapi adaptors that come with IPCE (see
> https://svn.sourceforge.net/svnroot/fepy/trunk/dbapi/). Do these work
> with SA?
>
> Which of the listed drivers will work with IronPython? I thought they
> were binary, or used win32 extensions.
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
