I'm not a database expert. Aren't both of those connection strings equivalent in the DAL? Why are you saying they are different?
Does the Trusted_Connection = YES part tell it to connect to the database using Windows Authentication? The main thing I'm trying to do is tell it to connect via Windows Authentication in SQL Server 2005 and not SQL Server Authentication. I thought Brian/Massimo had worked out a patch to allow for windows authentication, but I was unclear as to how the connection string should look in that case. Brian asked the same question, but it seems it was never answered. On Wednesday, October 2, 2013 4:50:34 PM UTC-4, Niphlod wrote: > > use mssql://oledb_connection_string where oledb_connection_string is the > "default" oledb formatted connection string. > > > http://www.connectionstrings.com/sql-server-native-client-11-0-oledb-provider/ > > basically as long as there isn't a @ in it, the connection string will be > used as it is with pyodbc, while if there is a @ in it, the connection > string is "similar" to the usual user:pass@host/database > > On Wednesday, October 2, 2013 9:56:15 PM UTC+2, Josh Myers wrote: >> >> Brian and/or Massimo, >> >> Did this issue ever get resolved so that the DAL can connect with windows >> authentication? If so, what is the syntax for the connection string? >> >> Thanks. >> >> - Josh >> > -- 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.
