Sorry for the noob question. Why do I only end up with 2 inserted
rows when doing this?
from sqlalchemy import *
db = create_engine('mysql://login:[EMAIL PROTECTED]/database')
metadata = BoundMetaData(db)
temptable = Table('temptable', metadata,
... Column('col1', Integer),
...
would be the table 'zone'; the second the schema
'dbo'.
On 6/12/07, one.person [EMAIL PROTECTED] wrote:
Thanks for all the quick replies. Currently on pyodbc 2.0.3.6.
Anyway, I tried this (the table 'zones' most definitely exists):
metadata.engine.echo = True
zones_table = Table
Hello all
I am experimenting with SA on MSSQL and am having difficulty with
table reflection as outlined in the tutorial, for instance:
from sqlalchemy import *
db = create_engine('mssql://login:[EMAIL PROTECTED]/db')
metadata = BoundMetaData(db)
users_table = Table('users', metadata,
one.person
View profile
More options Jun 12, 5:12 pm
From: one.person [EMAIL PROTECTED]
Date: Wed, 13 Jun 2007 00:12:50 -
Local: Tues, Jun 12 2007 5:12 pm
Subject: Re: mssql reflection NoSuchTableError
Reply | Reply to author | Forward | Print | Individual message | Show
original
So all of the above was done with Windows XP, Python 2.4.3, pymssql
0.7.4, and MSSQL 2000. I upgraded to pymssql 0.8.0 with the same
results. I uninstalled that and installed pyodbc 2.0.3.6, same
results.
The obvious differences between my installation and yours is that I am
using MSSQL 2000
Thanks for all the quick replies. Currently on pyodbc 2.0.3.6.
Anyway, I tried this (the table 'zones' most definitely exists):
metadata.engine.echo = True
zones_table = Table('zones', metadata, autoload=True)
2007-06-12 18:20:40,924 INFO sqlalchemy.engine.base.Engine.0x..b0 SET
nocount ON