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
-~----------~----~----~----~------~----~------~--~---
