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 [email protected]
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
-~----------~----~----~----~------~----~------~--~---
