Additonal to Denes, I'm using Microsoft SQL Server 2008 Express and successfully connection with this.
db = DAL("mssql://UserID:Password@ComputerName\SQLEXPRESS/ DatabaseName") On Aug 31, 1:52 pm, DenesL <denes1...@yahoo.ca> wrote: > The connection string seems ok but: > - check user and password > - leave out the port (1433 is the default) > - if yo are using the Express version add the instance name e.g. > POPE\\SQLEXPRESS/xPAC > > On Aug 31, 2:25 pm, patrick moon <pmo...@gmail.com> wrote: > > > > > > > > > I'm using the doc suggested connection string: > > > db = DAL('mssql://shxxx:shaxxx@POPE:1433/xPAC') > > > and this is the error I'm getting: > > > Traceback (most recent call last): > > File "gluon/restricted.py", line 192, in restricted > > File "C:/_dev/temp/web2py/applications/welcome/models/db.py", line > > 18, in <module> > > File "gluon/dal.py", line 3981, in __init__ > > RuntimeError: Failure to connect, tried 5 times: > > 'NoneType' object has no attribute 'connect' > > > Appreciate any help....