Hello All,
Greetings.
I'm new to web2py. I'm trying to build a dynamic webpage using web2py(Python
2.7) and sql server at the backend. While I'm able to connect to sql server
using sql management studio and work, I cannot connect to sql using web2py.
There are a lot of solutions offered on this group, probably I'm the
incompetent one not being able to use those fruitfully.
I'm using Python on a Windows 64 bit machine, and using 32 bit version of
Python. I have used 64 bit version, and got the same errors that I get now.
List of problems:
I used this code in db.py: db= DAL(mssql://username:password @
servername\schema/database) (please ignore the underline)
And get a big error :
<type 'exceptions.RuntimeError'> Failure to connect, tried 5 times.
But when I use db= DAL(sqlite://webform.sqlite), everything works fine.
2. When I try to import pyodbc using Python 2.7 IDLE, I get this:
ImportError: No module named pyodbc.
3. When web2py starts, it lists the " Database drivers available" at the
console. I can see pymysql, Mysqldb, sqlitee3 and pyodbc among others, but not
MSSQLDb. Is that a problem?
Thank you for your time in advance.
-Som
--
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.
