On Jan 17, 2008 3:27 PM, Rick Morrison <[EMAIL PROTECTED]> wrote: > Adodbapi is Windows-only, you're definitely barking up the wrong tree with > that one. > > Pyodbc on Linux is theoretically possible, but I know of no users and have > very little experience myself with it. > Pymssql is supported on Linux, and it works within certain restrictions (30 > char identifier length, no unicode) as outlined on the SQLAlchemy wiki. > > You're pretty much breaking new ground if you're trying pyodbc + SQLAlchemy > + Unix. Not that I'm discouraging that, I've been meaning to tackle it, but > just so you know.... > > But Linux + adodbapi is not going to fly at all. >
I moved to pyodbc but I keep getting this connection error. I tried: eng = create_engine('mssql:///?dsn=mydsn',module=pyodbc) and: eng = create_engine('mssql://user:[EMAIL PROTECTED]',module=pyodbc) metadata = BoundMetaData(eng) eng.echo=True quote = Table('quotetable', metadata, autoload=True) but I get the same error. How do I pass the USR=username PWD=password to my dsn connection string in sqlalchemy? File "/usr/lib/python2.4/site-packages/sqlalchemy/pool.py", line 111, in create_connection return _ConnectionRecord(self) File "/usr/lib/python2.4/site-packages/sqlalchemy/pool.py", line 149, in __init__ self.connection = self.__connect() File "/usr/lib/python2.4/site-packages/sqlalchemy/pool.py", line 174, in __connect connection = self.__pool._creator() File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/strategies.py", line 57, in connect raise exceptions.DBAPIError("Connection failed", e) sqlalchemy.exceptions.DBAPIError: (Connection failed) (TypeError) function takes at least 1 argument (0 given) 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 -~----------~----~----~----~------~----~------~--~---