Thank you, everyone. The problem of how to sign in with windows
authorization was solved for me when I used the following connection string
in SQL Server 2005:
db = DAL('mssql://DRIVER={SQL
Server};SERVER:ServerName;DATABASE=DatabaseName;TRUSTED_CONNECTION=YES;')
For some reason it needed that DRIVER statement. That was also the same
connection string that worked using pyodbc explicitly, so that makes sense
I guess.
On Thursday, October 3, 2013 4:53:55 AM UTC-4, Niphlod wrote:
>
>
> Il giorno giovedì 3 ottobre 2013 01:20:40 UTC+2, Josh Myers ha scritto:
>>
>> I'm not a database expert.
>>
>> Aren't both of those connection strings equivalent in the DAL? Why are
>> you saying they are different? I will try it in the other format, the
>> non-@ format.
>>
>> ehm.
>
> mssql://Provider=SQLNCLI11;Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
> vs
> mssql://myUsername:myPassword@myServerAddress/myDataBase
>
> to me are different.
> That being said, there are a few options (especially with integrated auth)
> that aren't "included" in the usual notation, so the only way is to use the
> former notation.
>
>
--
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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
