whoops, linked the slightly wrong page :)
http://www.connectionstrings.com/sql-server-native-client-11-0-odbc-driver/
On Thursday, October 3, 2013 6:39:19 PM UTC+2, Josh Myers wrote:
>
> 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.
