Accessing SQL View with Python

[kyosohma at gmail.com]

On Apr 27, 10:29 am, Tim Golden <m... at timgolden.me.uk> wrote:
> kyoso... at gmail.com wrote:
> > Hi All,
>
> > I need to access a Microsoft SQL database View. Is there a way to do
> > this with Python? I have done a fair share of "googling" and found
> > nothing on accessing Views, just executing SQL, which I already know
> > how to do.
>
> > I am running Windows XP, Python 2.4.
>
> Absolutely loads of ways. But (unless I'm missing
> something here) they all involve executing SQL
> which accesses a View (such as: SELECT * FROM v_info).
> Have I missed the point of your question?
>
> TJG

I figured there was. And yes, I knew you'd need to use SQL to get at
the View. I just re-ran it and discovered that I am quite good at
typos. I corrected the SQL and it seems to be working now.

Thanks for the help.

Mike