if you didnt have this problem with pymssql then please apply the patch I sent
previously.
However, I'm going to bet the problem remains as it seems something is not
right with how your database and/or client is configured. I'm not familiar
with the encoding pattern seen in your information_schema queries. you may
have to reproduce the issue using plain SELECT statements against
information_schema and then seek outside help.
diff -r 17cab4ad55d5 lib/sqlalchemy/dialects/mssql/pymssql.py
--- a/lib/sqlalchemy/dialects/mssql/pymssql.py Thu Oct 04 18:26:55 2012 -0400
+++ b/lib/sqlalchemy/dialects/mssql/pymssql.py Fri Oct 05 18:46:01 2012 -0400
@@ -80,7 +80,7 @@
def _get_server_version_info(self, connection):
vers = connection.scalar("select @@version")
m = re.match(
- r"Microsoft SQL Server.*? - (\d+).(\d+).(\d+).(\d+)", vers)
+ r"\s*Microsoft SQL Server.*? - (\d+).(\d+).(\d+).(\d+)", vers)
if m:
return tuple(int(x) for x in m.group(1, 2, 3, 4))
else:
On Oct 8, 2012, at 12:10 PM, Ladislav Lenart wrote:
> Hello.
>
> I adjusted the ODBC/FreeTDS condifugration according to your suggestions but
> still get the "NoSuchTableError: mlm_spol".
>
> freetds.conf:
>
> [zfp]
> host = 10.230.128.140
> port = 1433
> tds version = 8.0
> asa database = ZFP_CRM
> client charset = utf8
> text size = 50000000
>
>
> odbc.ini:
>
> [ODBC Data Sources]
> zfp = test
>
> [zfp]
> Driver = /usr/lib/libtdsodbc.so
> Description = test
> Trace = No
> Servername = zfp
>
>
> odbcinst.ini (for the sake of completeness):
>
> [FreeTDS]
> Driver = /usr/lib/libtdsodbc.so
> UsageCount = 2
>
>
> The code:
>
> from sqlalchemy.engine import create_engine
> from sqlalchemy.ext.sqlsoup import SqlSoup
>
> if __name__ == '__main__':
> engine = create_engine("mssql://efractal:efR@cZFP13@zfp", echo='debug')
> db = SqlSoup(engine)
> x = db.mlm_spol.fetchone()
> print x
>
>
> still fails with NoSuchTableError: mlm_spol
>
> Its debug output is the same as in my previous email which used different
> connect style.
>
> And the code that uses db.execute('select * from mlm_spol').fetchone() still
> works...
>
> Any other ideas?
>
> Ladislav Lenart
>
>
> On 8.10.2012 17:45, Michael Bayer wrote:
>> your freetds datasource should be configured with CLIENT_CHARSET=utf8 as I
>> illustrated earlier:
>>
>> [ms_2005]
>> host = 172.16.248.128
>> port = 1213
>> tds version = 8.0
>> client charset = UTF8
>> text size = 50000000
>
--
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.
