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 sqlalchemy@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
