Ach my sqlserver instance seems to just take a long time and I'm
too impatient.
create_engine('mssql://localhost/some_db_name') takes 10 seconds for
some reason, but it does work.
weird.
vic
On Apr 16, 11:09 am, Victor Ng [EMAIL PROTECTED] wrote:
Is there a simple example of how to
I'm getting some pretty strange behavior when connecting to SQL
Server.
My code is pretty straight forward, just create an engine, create
metadata, introspect on a table...
from sqlalchemy import *
db = create_engine('mssql://./msdb')
meta = BoundMetaData(db)
tbl = Table('sysdtssteplog', meta,
Oops - fingers are faster than my brain. Here's the snippet from the
second attempt at creating a Table using autoload, and it succeeds.
---
In [10]: tbl = Table('sysdtssteplog', meta, autoload=True)
In [11]: [c.name for c in tbl.columns]
Out[11]:
['stepexecutionid',
'lineagefull',
It sounds like its getting to be time to make pyodbc the preferred DBAPI
interface for MSSQL. I'll start a new thread to see if there's any
objections.
On 4/16/07, Victor Ng [EMAIL PROTECTED] wrote:
Sweet! This seems to work well now.
Is there a way I can update the documentation for the