Wow, that's great. I tried that a while ago and I had issues. I created issues for the developer but I wasn't aware he had fixed them.
https://github.com/denisenkom/pytds/issues/33 I had to use some hacks to get mine to work with TDS, but once I did that, I can use it in pypy, with full speedups. On Wednesday, July 1, 2015 at 2:49:46 AM UTC-7, Massimiliano wrote: > > Maybe could be useful to someone.. . > > I found that for my needs, I can got with python-tds, that is pure python. > > Thank you > > On Tuesday, June 30, 2015 at 2:49:40 PM UTC+2, Massimiliano wrote: >> >> Hello, >> >> I've a problem with odbc. >> >> I'm developing on OSX 10.10.3 and I found some problems connecting to sql >> server express 2005 >> >> I'm tried few things >> >> 1. I installed pyodbc and web2py said: >> >> Version 2.10.4-stable+timestamp.2015.04.26.15.11.54 >> Database drivers available: psycopg2, pymysql, imaplib, sqlite3, pg8000, >> pyodbc >> >> but from ipython: >> >> import pyodbc >> gave me an error. >> >> tracing web2py, it failed importing pyodbc... It's normal that web2py >> includes pyodbc in drivers available if it fail to import pyodbc? >> >> 2. I installed from brew unixodbc >> >> but now, when I try to connect to mssql with the following connection >> strings: >> >> db = DAL("mssql://sa:...@192.168.0.19 <javascript:>\SQLEXPRESS/TESTDB") >> or >> db = DAL("mssql3://sa:...@192.168.0.19 <javascript:>\SQLEXPRESS/TESTDB") >> I got this error: >> >> RuntimeError: Failure to connect, tried 5 times: >> Traceback (most recent call last): >> File "pydal/base.py", line 435, in __init__ >> self._adapter = ADAPTERS[self._dbname](**kwargs) >> File "pydal/adapters/base.py", line 53, in __call__ >> obj = super(AdapterMeta, cls).__call__(*args, **kwargs) >> File "pydal/adapters/mssql.py", line 155, in __init__ >> if do_connect: self.reconnect() >> File "pydal/connection.py", line 105, in reconnect >> self.connection = f() >> File "pydal/adapters/mssql.py", line 153, in connector >> return self.driver.connect(cnxn, **driver_args) >> Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'SQL >> Server' : file not found (0) (SQLDriverConnect)") >> >> >> Could someone help me? >> The application with be deployed on debian 7, do you think there are >> problems also there? >> >> Thank you >> >> -- >> Massimiliano >> > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
