web2py doesn't use freetds by default as a driver, but SQL Server... so if
you can connect with freetds 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
Hi
Please see here [1]
José
[1]
https://groups.google.com/forum/#!searchin/web2py/Help$20with$20MSSQL$20Connection/web2py/fFgJMgYHbBQ/ZLji6jjkYzEJ
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
-
Thanks.
I have web2py installed in a virtual environment. (basically just unzipped
in to the venv). `which python` confirms that `python web2py.py` is using
the venv python.
The error message changes when I out-comment the import pypyodbc statement
and just call the DAL directly
px = DAL
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 drivers available: sqlite3, imaplib, pyodbc, pymysql, pg8000
I guess pyodbc here is
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
Hi again Jose
Since my error mesage now says something like:
Data source name not found, and no default driver specified')
I decided to try the DNS route.
I have tried to edit both /usr/share/freetds/freetds.conf and
/etc/freetds/freetds.conf. In both cases I added a DNS. That changed
nothing.
Thanks again Niphlod
I don't think using SQL server is an option in linux-land? All the
examples I have seen uses FreeTDS.
On Monday, July 13, 2015 at 6:34:30 PM UTC+2, Niphlod wrote:
web2py doesn't use freetds by default as a driver, but SQL Server... so if
you can connect with freetds
freetds with (py)pyodbc MUST have freetds as a proxy to connect from a
linux host. The trick is understanding what parameters needs to be passed
to py(pyodbc) to connect.
As mssql is usually used from windows host, the default
connectionstring-builder uses parameters that are valuable when
On 13/07/2015 16:02, 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.
For a non-web2py application, I
9 matches
Mail list logo