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.
