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