Hello.
I try to access a Microsoft SQL database from Linux (Debian testing):
from sqlalchemy.ext.sqlsoup import SqlSoup
conn_string = 'mssql+pymssql://user:pass@freetds_name'
db = SqlSoup(conn_string)
v = db.some_table.first()
print v
freetds_name is the section name from /etc/freetds/freetds.conf
[freetds_name]
host = ...
port = 1433
tds version = 7.1
asa database = DB
The above script fails in pymssql on line 83, because line 81 sets vers to None:
def _get_server_version_info(self, connection):
vers = connection.scalar("select @@version")
m = re.match(
r"Microsoft SQL Server.*? - (\d+).(\d+).(\d+).(\d+)", vers)
if m:
return tuple(int(x) for x in m.group(1, 2, 3, 4))
else:
return None
But the following works in tsql:
1> select @@version
2> go
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64)
Apr 22 2011 19:23:43
Copyright (c) Microsoft Corporation
Workgroup Edition (64-bit) on Windows NT 6.1 <X64>
(Build 7601: Service Pack 1) (Hypervisor)
(1 row affected)
Any idea what is wrong?
Thank you,
Ladislav Lenart
--
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.
