Okay - so I have now:

1.  sudo apt-get install tdsodbc unixodbc
2.- added path of libtdsodbc.so to /etc/odbcinst.ini ([FREETDS]Driver = 
path)

Now the error is not about ld_library_path but instead

Error: (u'IM002', u'[IM002] [unixODBC][Driver Manager]Data source name not 
> found, and no default driver specified')
>

Sincerely
Andreas


On Saturday, July 11, 2015 at 2:21:52 PM UTC+2, achristoffersen wrote:
>
> Trying to connect to mssql
>
> In models/px.py I have:
>
> import pypyodbc
>> px = DAL('mssql4://username:password@url,portnumber/databasename')
>>
>
> In controlers/default.py I have
>
> return px.executesql('SELECT top 1 * FROM table;')
>>
>
> I get this ticket:
>
>> <class 'pypyodbc.OdbcNoLibrary'> 'ODBC Library is not found. Is 
>> LD_LIBRARY_PATH set?'
>
>  
> If you run idle, and import pypyodbc I also get:
>
>> <class 'pypyodbc.OdbcNoLibrary'> 'ODBC Library is not found. Is 
>> LD_LIBRARY_PATH set?'
>
>
> google a bit, I can read that the variable is a: 
>
>>
>> List of directories where the system searches for runtime libraries in 
>> addition to those hard-defined by ld and in /etc/ld.so.conf.d/*.conf 
>> files
>>  
>
>
> But my linux mint doesnt have the variable set. And what should I set the 
> variable to, in my virtual environment where I run web2py? 
>
> Any help to get me started much appriciated.
>

-- 
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.

Reply via email to