i'd give it a try with the entire connection string (choosing also the
right driver installed on your machine)
db = DAL("mssql://Driver={Microsoft Access Driver (*.mdb)};Dbq=
C:\mydatabase.mdb;Uid=Admin;Pwd=;")
On Thursday, November 15, 2012 4:47:20 PM UTC+1, Willoughby wrote:
>
> Yea, sorry - we're still running an ancient version because of issues
> trying to upgrade.
> We're now looking at converting to Lightswitch instead.
>
> I believe it should be db=DAL for current versions and the connection
> string is normally mssql://user:pwd@server/database
>
>
> On Thursday, November 15, 2012 10:32:08 AM UTC-5, Simon Carr wrote:
>>
>> 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...
>>>
>>
--
