True - but most companies also block web servers internally - so you
wouldn't get far either way.
Unless you're doing a bundled stand alone...?
If so, have you looked at SQL Server Express?
It has a 'localdb' option if you want something you can run 'from the
desktop'.
On Thursday, November 15, 2012 11:46:23 AM UTC-5, Simon Carr wrote:
>
> Bat Man strikes again, That seems to work perfectly to make the actual
> connection, unfortunately :-( there is an immediate error in the SQL as it
> tries to create the auth tables. Looks like it would require a specific
> connection object writing. It's a shame because most companies will not
> allow database servers setting up like MySQL Server out side the confines
> of the IT Department. SQLite is often not scaleable enough but MS Access
> fits just nicely in the middle ground and is readily available on users
> machines.
>
> What are the chances of a MS Access adapter being written?
>
> I had a look at gluon.py but without help to get me started I don't think
> I could do it.
>
> Simon
>
>
> On Thursday, 15 November 2012 16:17:12 UTC, Niphlod wrote:
>>
>> 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...
>>>>>
>>>>
--
