FYI. Although few if any examples are documented, it is possible to for example to connect to Microsoft SQLExpress this way
connStr = ( r'Driver={SQL Server};' + r'Server=(local)\SQLEXPRESS;' + r'Database=MyDB;' + r'Trusted_Connection=Yes;' ) dalstring = 'mssql://' + connStr db = DAL(dalstring) So you can put 'mssql:' followed by any connection string which is acceptable to pyodbc. The web2py book only gives this connection string example: mssql://username:password@localhost/test Likely the same is also true for the other DAL connection types for whatever driver the type uses. NOTE: You have to download,and run the pyodbc Windows Installer from https://code.google.com/p/pyodbc/downloads/list -- 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/groups/opt_out.