Hi,
We're trying to use SQLAlchemy with MS SQL Server 2000 using stored
procedures. We connect to the server doing something like this:
engine = sqlalchemy.create_engine('mssql://
user:[EMAIL PROTECTED]/db')
cur = engine.connect()
print cur.execute("execute stored_proc @query='gra%';").fetchall()
This gives us the following traceback:
Traceback (most recent call last):
File "\\ubuntuwww\mcisroot\opt\Plone-2.5\sqltest.py", line 7, in
<module>
print cur.execute("execute sp_EDEN_Vendors (@query='gra
%');").fetchall()
File "c:\python25\lib\site-packages\sqlalchemy-0.4.5-py2.5.egg
\sqlalchemy\engine\base.py", line 844, in execute
return Connection.executors[c](self, object, multiparams, params)
File "c:\python25\lib\site-packages\sqlalchemy-0.4.5-py2.5.egg
\sqlalchemy\engine\base.py", line 854, in _execute_text
self.__execute_raw(context)
File "c:\python25\lib\site-packages\sqlalchemy-0.4.5-py2.5.egg
\sqlalchemy\engine\base.py", line 916, in __execute_raw
self._cursor_execute(context.cursor, context.statement,
context.parameters[0], context=context)
File "c:\python25\lib\site-packages\sqlalchemy-0.4.5-py2.5.egg
\sqlalchemy\engine\base.py", line 960, in _cursor_execute
self._handle_dbapi_exception(e, statement, parameters, cursor)
File "c:\python25\lib\site-packages\sqlalchemy-0.4.5-py2.5.egg
\sqlalchemy\engine\base.py", line 942, in _handle_dbapi_exception
raise exceptions.DBAPIError.instance(statement, parameters, e,
connection_invalidated=is_disconnect)
DatabaseError: (DatabaseError) internal error: None "execute
sp_EDEN_Vendors (@query='gra%');" {}
If we take out the "@query='gra%';" part, it runs fine. However, we
need to be able to pass arguments to the stored procedure. How do we
do this?
Thanks!
Mike
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
