C:\Dev\pysched>python createservers.py D:\Python26\lib\site-packages\sqlalchemy-0.5.3-py2.6.egg\sqlalchemy\databases\ms sql.py:977: DeprecationWarning: object.__new__() takes no parameters return super(MSSQLDialect, cls).__new__(cls, *args, **kwargs) 2009-04-17 18:29:10,421 INFO sqlalchemy.engine.base.Engine.0x...0270 BEGIN 2009-04-17 18:29:10,437 INFO sqlalchemy.engine.base.Engine.0x...0270 INSERT INTO [SERVERS] ([SERVER], [IP], [PORT], [OS], [JSERVER], [STARTED], [STDIN], [LOGIN] , [CWD], [ASSIGNEDONLY]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 2009-04-17 18:29:10,437 INFO sqlalchemy.engine.base.Engine.0x...0270 ['agent1', '192.168.0.100', 2000, 0, None, 1, 1, 1, 1, 0] 2009-04-17 18:29:10,500 INFO sqlalchemy.engine.base.Engine.0x...0270 ROLLBACK Traceback (most recent call last): File "createservers.py", line 9, in <module> session.flush() File "d:\python26\lib\site-packages\sqlalchemy-0.5.3-py2.6.egg\sqlalchemy\orm\ session.py", line 1351, in flush self._flush(objects) File "d:\python26\lib\site-packages\sqlalchemy-0.5.3-py2.6.egg\sqlalchemy\orm\ session.py", line 1422, in _flush flush_context.execute() File "d:\python26\lib\site-packages\sqlalchemy-0.5.3-py2.6.egg\sqlalchemy\orm\ unitofwork.py", line 244, in execute UOWExecutor().execute(self, tasks) File "d:\python26\lib\site-packages\sqlalchemy-0.5.3-py2.6.egg\sqlalchemy\orm\ unitofwork.py", line 707, in execute self.execute_save_steps(trans, task) File "d:\python26\lib\site-packages\sqlalchemy-0.5.3-py2.6.egg\sqlalchemy\orm\ unitofwork.py", line 722, in execute_save_steps self.save_objects(trans, task) File "d:\python26\lib\site-packages\sqlalchemy-0.5.3-py2.6.egg\sqlalchemy\orm\ unitofwork.py", line 713, in save_objects task.mapper._save_obj(task.polymorphic_tosave_objects, trans) File "d:\python26\lib\site-packages\sqlalchemy-0.5.3-py2.6.egg\sqlalchemy\orm\ mapper.py", line 1347, in _save_obj c = connection.execute(statement.values(value_params), params) File "d:\python26\lib\site-packages\sqlalchemy-0.5.3-py2.6.egg\sqlalchemy\engi ne\base.py", line 824, in execute return Connection.executors[c](self, object, multiparams, params) File "d:\python26\lib\site-packages\sqlalchemy-0.5.3-py2.6.egg\sqlalchemy\engi ne\base.py", line 874, in _execute_clauseelement return self.__execute_context(context) File "d:\python26\lib\site-packages\sqlalchemy-0.5.3-py2.6.egg\sqlalchemy\engi ne\base.py", line 896, in __execute_context self._cursor_execute(context.cursor, context.statement, context.parameters[0 ], context=context) File "d:\python26\lib\site-packages\sqlalchemy-0.5.3-py2.6.egg\sqlalchemy\engi ne\base.py", line 950, in _cursor_execute self._handle_dbapi_exception(e, statement, parameters, cursor, context) File "d:\python26\lib\site-packages\sqlalchemy-0.5.3-py2.6.egg\sqlalchemy\engi ne\base.py", line 931, in _handle_dbapi_exception raise exc.DBAPIError.instance(statement, parameters, e, connection_invalidat ed=is_disconnect) sqlalchemy.exc.ProgrammingError: (ProgrammingError) ('42S02', "[42S02] [Microsof t][ODBC SQL Server Driver][SQL Server]Invalid object name 'SERVERS'. (208) (SQLE xecDirectW); [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (8180)") u'INSERT INTO [SERVERS] ([SERVER], [IP], [PORT] , [OS], [JSERVER], [STARTED], [STDIN], [LOGIN], [CWD], [ASSIGNEDONLY]) VALUES (? , ?, ?, ?, ?, ?, ?, ?, ?, ?)' ['agent1', '192.168.0.100', 2000, 0, None, 1, 1, 1 , 1, 0]
C:\Dev\pysched> On Fri, Apr 17, 2009 at 5:05 PM, Michael Trier <mtr...@gmail.com> wrote: > > On Apr 17, 2009, at 5:46 PM, Michael Mileusnich <justmike2...@gmail.com> > wrote: > > First, thanks for being patient and assisting me. I am very thankful. > > MS SQL 2005 is the db I am running. > > part of my db.py script: > > try: > connection = config.get("db", "connection") > except: > print "No Database Specified" > sys.exit(1) > > engine = create_engine(connection) > > metadata = MetaData(engine) > > Session = scoped_session(sessionmaker(bind=engine, autoflush=False, > autocommit=True)) > > action_table = Table( > 'ACTIONS', metadata, > Column('ACTIONID', String(48), primary_key=True), > Column('TITLE', String(128)), > Column('CMDLINE', String(512)), > Column('STDIN', Text), > Column('STARTINDIR', String(512)), > Column('PRIO', Integer), > Column('USERID', Integer, ForeignKey('USERS.USERID'))) > > ... > more tables here > ... > etc > > mapper(action, action_table) > > here is my create: > > new_action = action(ACTIONID = '500', CMDLINE = 'sol') > session.add(new_action) > session.flush() > > also how do I turn on echo? > > On Fri, Apr 17, 2009 at 3:24 PM, Michael Trier < <mtr...@gmail.com> > mtr...@gmail.com> wrote: > >> On Fri, Apr 17, 2009 at 2:01 AM, Michael Mileusnich <<justmike2...@gmail.com> >> justmike2...@gmail.com> wrote: >> >>> I am still having issues with pyodbc on Python 2.6. >>> >>> Platform: Windows XP SP3 32 bit >>> Python 2.6 >>> SQLAlchemy 0.5.3 >>> pyodbc 2.1.3 >>> >>> I run this exact setup without problems. Maybe if we see the script that >> will help. What version of MSSQL? >> >>> -- >>> Michael Trier >>> <http://blog.michaeltrier.com/>http://blog.michaeltrier.com/ >>> <http://thisweekindjango.com/>http://thisweekindjango. >> >> > engine = create_engine(connection, echo=True) > > > > --~--~---------~--~----~------------~-------~--~----~ 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 sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---