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