nope. Seems like the SQLA connection is still not using the
appropriate magical incantation to get all that ODBC stuff to behave
reasonably.
might I suggest just circumventing the URL entirely and just using
creator=lambda:
pyodbc
.connect
("DRIVER
={TDS};SERVER=xxxxxxxx;UID=xxxx;PWD=xxxx;TDS_Version=7.0") ? for
something this incredibly hacked and specific, it seems like the right
way to go.
On Apr 18, 2008, at 3:35 PM, Lukasz Szybalski wrote:
> On Wed, Apr 2, 2008 at 4:24 PM, Michael Bayer <[EMAIL PROTECTED]>
> wrote:
>> Gottit. Notice, pyodbc is truncating all the column names to 30
>> characters.
>> anyway, thats why its broken. Is this a bug in pyodbc ? I
>> thought MS-SQL
>> has a much bigger limit than this ?
>>
>
>
> I finally got the driver name and tds version into sqlalchemy and it
> should be passing it on to pyodbc but it doesn't seem to work.
>
> I'm attaching a file. I have query to mssql via pyodbc and tds 7/8 and
> it returns long field description.
>
> but same thing in sqlalchemy doesn't.
>
> Is there some other processing done on it?
>
> Here is the file.
> Thanks,
> Lucas
> <sqlalchemy3.txt>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
