you may have multiple versions of python installed.
On Wednesday, 1 July 2015 14:50:49 UTC-5, JC wrote:
>
> 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:...@192.168.0.19\SQLEXPRESS/TESTDB")
>> or
>> db = DAL("mssql3://sa:...@192.168.0.19\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.
