As far as I know a view is treated like a table in SA - if you're getting
the query to run at all, it's most likely that SA is issuing a different
query that what you thought it might. Either use the SQL profiler in MSSQL
to see the actual SQL going over the wire, or turn on logging in SA to see
what queries are being issued. Odds are you're sending two different
queries.
On 3/28/07, Lee Connell <[EMAIL PROTECTED]> wrote:
>
>
> pyodbc seems to do the trick. Thanks for the recommendation. I am
> having problem selecting from views in ms sql database, it returns 0
> rows, using the same statement in enterprise manager returns a bunch
> of rows. Is there anything special I need to do for selecting data
> from views?
>
> On Mar 28, 1:01 pm, "Rick Morrison" <[EMAIL PROTECTED]> wrote:
> > DBlib is deprecated by MS, and it hasn't been updated in like five
> years,
> > and is just never going to be updated ever.
> >
> > If you can't change the name of the database, then I would take a look
> at
> > replacing pymssql with pyodbc, I have heard of people having good luck
> with
> > it (Paul, want to jump in here?)
> >
> > Rick
> >
> > On 3/28/07, Lee Connell <[EMAIL PROTECTED]> wrote:
> >
> >
> >
> > > There is a fix for column names, however I don't see anything to
> > > overcome this issue if the database name is more than 30 chars? Any
> > > suggestions?
> >
> > > On Mar 28, 12:44 pm, "Lee Connell" <[EMAIL PROTECTED]> wrote:
> > > > the table I'm trying to grab is under 30 chars. Is there a way to
> > > > change this limit?
> >
> > > > On Mar 28, 12:23 pm, "Rick Morrison" <[EMAIL PROTECTED]> wrote:
> >
> > > > > Pymssql uses DBlib under the covers, and
> > > > > there's a 30-character identifier limit in DBlib.
> >
> > > > > That limit applies to any identifier, including table and column
> > > names,
> > > > > which might explain your second issue.
> >
> > > > > Rick
> >
> > > > > On 3/28/07, Lee Connell <[EMAIL PROTECTED]> wrote:
> >
> > > > > > I am using these tools on a windows machine. Some problems I
> ran
> > > > > > into.
> >
> > > > > > First of all I can't connect to a database that's name is more
> than
> > > 30
> > > > > > chars long. Error returned says it can't find the database and
> the
> > > > > > database it's looking for has been truncated.
> >
> > > > > > When I connect to a database less than 30 chars long, I try to
> load
> > > a
> > > > > > table and it complains that it cannot find the table. The table
> is
> > > > > > definitely there and I've tried many different table names as
> well
> > > > > > that are available in the DB. Anyone know of a fix or is this a
> bug?
> >
> > > > > > ####### Here is my code. #############
> >
> > > > > > from sqlalchemy import *
> >
> > > > > > db_name = "this_is_a_test_of_a_long_database_string"
> > > > > > db_user = "lee"
> > > > > > db_pass = "****"
> > > > > > db_conn = "mssql://%s:[EMAIL PROTECTED]/%s" % (db_user,
> db_pass,
> > > > > > db_name)
> >
> > > > > > db = create_engine(db_conn, echo=True)
> > > > > > metadata = BoundMetaData(db)
> >
> > > > > > users_table = Table("syscolumns", metadata, autoload=True)
> > > > > > list(users_table.columns)[0].name
> >
> > > > > > # Ammonoosuc_Computer_Services_MSCRM
> > > > > > # "FilteredServiceAppointment"
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
