at 8:02:07 AM UTC+2, achristoffersen wrote:
(x-post from stackoverflow:
http://stackoverflow.com/questions/31371462/web2py-cant-connect-to-mssql-via-pypyodbc-but-possible-to-connect-from-idle
)
I can connect via 'naked' pypyodbc, but not via the web2py DAL.
I installed pypyodbc as per
Hi Jose,
Thanks
Okay - So if I run python web2py -M
I get this:
Version 2.11.2-stable+timestamp.2015.05.30.16.33.24
Database drivers available: sqlite3, imaplib, pyodbc, pymysql, pg8000
I guess pyodbc here is really pypyodbc?
A
Also: Thanks for the pointers. Is your recommendation to use
. I still get
Data source name not found, and no default driver specified')
Sincerely
On Monday, July 13, 2015 at 10:00:08 PM UTC+2, achristoffersen wrote:
Hi Jose,
Thanks
Okay - So if I run python web2py -M
I get this:
Version 2.11.2-stable+timestamp.2015.05.30.16.33.24
Database
with pypyodbc it's not said that the same
works within web2py (unless you use the same driver args).
That being said, the error no driver available smells. How did you
install web2py ?
On Monday, July 13, 2015 at 8:02:07 AM UTC+2, achristoffersen wrote:
(x-post from stackoverflow:
http
(x-post from stackoverflow:
http://stackoverflow.com/questions/31371462/web2py-cant-connect-to-mssql-via-pypyodbc-but-possible-to-connect-from-idle)
I can connect via 'naked' pypyodbc, but not via the web2py DAL.
I installed pypyodbc as per these instructions:
As the problem was not with LD_LIBRARY_PATH, but instead that I didn't
follow these instructions
https://code.google.com/p/pypyodbc/wiki/Linux_ODBC_in_3_steps I close this
question and ask another one.
Thanks
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
-
, 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
, 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
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
nothing.
(p.s running ubuntu 14.04)
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
10 matches
Mail list logo