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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.