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 </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 > --
