> sounds like something is crashing inside the DBAPI driver. try
> taking whatever SQL output is printed and trying it manually.
Doesn't even make it that far. I shortened the program even more to
this and have the same problem:
from sqlalchemy import *
connectionString = 'mssql://sa:[EMAIL PROTECTED]:1433/ServerMonitor'
#connectionString = 'sqlite:///'
engine = create_engine(connectionString, echo=True)
meta = MetaData(engine)
Services = Table( 'Services', meta, Column('ID', Integer,
primary_key=True), Column('Name', String(255)), )
print "test"
meta.create_all(engine)
print "the end"
If I leave the code as is, I get:
(--START--)
C:\>test.py
test
2007-10-19 16:26:45,421 INFO sqlalchemy.engine.base.Engine.0x..d0
PRAGMA table_i
nfo("Services")
2007-10-19 16:26:45,421 INFO sqlalchemy.engine.base.Engine.0x..d0 {}
2007-10-19 16:26:45,421 INFO sqlalchemy.engine.base.Engine.0x..d0
CREATE TABLE "Services" (
"ID" INTEGER NOT NULL,
"Name" VARCHAR(255),
PRIMARY KEY ("ID")
)
2007-10-19 16:26:45,437 INFO sqlalchemy.engine.base.Engine.0x..d0 {}
2007-10-19 16:26:45,437 INFO sqlalchemy.engine.base.Engine.0x..d0
COMMIT
the end
(--END--)
If I comment out the sqlite string, I get:
(--START--)
C:\>test.py
test
(--END--)
It seems that nobody else is having as trivial a problem as I am...
what are some of the common trivial mistakes newbies to db's and
python make? I'm beginning to think its something really basic.
Shouldn't matter that its running in VM right? :)
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---