Hello
I had a similar problem, causes by 2 things: 1- sql configuration was
wrong. 2- I need to specify the path fro the pyodbc location.
Hope this help you
On Tuesday, June 30, 2015 at 1:49:40 PM UTC+1, 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:[email protected] <javascript:>\SQLEXPRESS/TESTDB")
> or
> db = DAL("mssql3://sa:[email protected] <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 [email protected].
For more options, visit https://groups.google.com/d/optout.
