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