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:[email protected]\SQLEXPRESS/TESTDB")
or
db = DAL("mssql3://sa:[email protected]\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 [email protected].
For more options, visit https://groups.google.com/d/optout.
