I get the following error. After this i tried installing pymssql which
requires a minimum of python 2.4 and all i have is python 2.3
Any way out for us python 2.3 users ?
db = create_engine('mssql://wscmsql/ws market datasql.db')
File "c:\python25\lib\site-packages\SQLAlchemy-0.4.5-py2.5.egg
\sqlalchemy\engine\__init__.py", line 160, in create_engine
return strategy.create(*args, **kwargs)
File "c:\python25\lib\site-packages\SQLAlchemy-0.4.5-py2.5.egg
\sqlalchemy\engine\strategies.py", line 62, in create
dbapi = dialect_cls.dbapi(**dbapi_args)
File "c:\python25\lib\site-packages\SQLAlchemy-0.4.5-py2.5.egg
\sqlalchemy\databases\mssql.py", line 452, in dbapi
raise ImportError('No DBAPI module detected for MSSQL - please
install pyodbc, pymssql, or adodbapi')
ImportError: No DBAPI module detected for MSSQL - please install
pyodbc, pymssql, or adodbapi
On May 15, 9:34 pm, "Lukasz Szybalski" <[EMAIL PROTECTED]> wrote:
> On Thu, May 15, 2008 at 12:51 PM, Yannick Gingras <[EMAIL PROTECTED]> wrote:
>
> >TkNeo<[EMAIL PROTECTED]> writes:
>
> >> Hi,
>
> > Hello Tarun,
>
> >> This is my first encounter with sqlalchemy. I am trying to connect to
> >> an MS SQL server 2000 that is not on local host. I want to connect
> >> using Integrated Security and not use a specific username and
> >> password. Can anyone tell me the format of the connection string ?
>
> > I don't know about Integrated Security but we use alchemy to connect
> > to a MSSQL from a GNU/Linux box and it works really well. We use Unix
> > ODBC with TDS with the DSN registered with the local ODBC.
>
> > Take a look at
>
> >http://www.lucasmanual.com/mywiki/TurboGears#head-4a47fe38beac67d9d03...
>
> > My obdb.ini looks like
>
> > [JDED]
> > Driver = TDS
> > Trace = No
> > Server = 192.168.33.53
> > Port = 1433
>
> > and my alchemy connection string is
>
> > mssql://user:pass@/?dsn=JDED&scope_identity=1
>
> Not sure what platform you are using but on linux I use:
> e = sqlalchemy.create_engine("mssql://user:[EMAIL
> PROTECTED]:1433/database?driver=TDS&odbc_options='TDS_Version=8.0'")
> but you need sa 0.4.6.
>
> on windows you can use:
> e = sqlalchemy.create_engine('mssql://user:[EMAIL PROTECTED]:1433/database')
>
> Lucas
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
