Should the connection string not start db=DAL(.....) If not how does this method of connection allow you to leverage the features of the Web2Py DAL
Thanks Simon On Thursday, 15 November 2012 15:11:02 UTC, Willoughby wrote: > > I use SQLServer but have never tried Access (except as a linked server > within SQL Server). > I'd imagine the connection string would look something like this: > db=SQLDB <http://examples/global/vars/SQLDB>( > 'mssql://user:user@<server>/<directory>/access.mdb') > Have no idea how the whole user id/password part would work though...could > try it without it and see if it flies... > > > On Thursday, November 15, 2012 9:26:11 AM UTC-5, Simon Carr wrote: >> >> There is very little information on this topic available on the internet. >> I have found one post where a user asked if Web2Py could be used with MS >> Access and a few users including Massimo suggested that it might be >> possible using the MSSql driver. There was no further information to >> suggest that this idea has been tested yet. >> >> While I understand the T-SQL is not entirely compatible with MS Access >> but most basic SQL statements such as Select, Update and Delete will work >> just fine. But in worst case I assume I should still be able to run raw SQL >> statements. >> >> If I wanted to Test Web2Py with PyODBC / MSSql to connect to MS Access >> what would the connection string look like? Bearing in mind that MS Access >> is a file based database and does not run behind an IP Address. >> >> Any help on this or anyone else's experience with Web2py and Access would >> be appreciated. >> >> Thanks >> Simon >> > --
