From: Richard B. <rb...@us...> - 2004-10-11 23:05:01
|
Update of /cvsroot/jcframework/dotnet In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv26300 Modified Files: CMsSqlDatabase.vb Log Message: Added SSPI login ability for MSSQLServer Index: CMsSqlDatabase.vb =================================================================== RCS file: /cvsroot/jcframework/dotnet/CMsSqlDatabase.vb,v retrieving revision 1.17 retrieving revision 1.18 diff -C2 -d -r1.17 -r1.18 *** CMsSqlDatabase.vb 28 Sep 2004 07:30:32 -0000 1.17 --- CMsSqlDatabase.vb 11 Oct 2004 23:03:38 -0000 1.18 *************** *** 51,62 **** pbroker.GetLoginDetails(Me, m_user, m_password) End If ! conn.Connection.ConnectionString = _ ! "Data Source=" & m_serverName & ";" & _ ! "Initial Catalog=" & m_name & ";" & _ ! "Integrated Security=false;" & _ ! "Persist Security Info=False;" & _ ! "User Id=" & m_user & ";" & _ ! "Password=" & m_password ! conn.Connection.Open() Catch ex As SqlClient.SqlException Throw New DatabaseConnectionException(ex.Message, ex) --- 51,70 ---- pbroker.GetLoginDetails(Me, m_user, m_password) End If ! If m_user = "SSPI" Then ! conn.Connection.ConnectionString = _ ! "Data Source=" & m_serverName & ";" & _ ! "Initial Catalog=" & m_name & ";" & _ ! "Integrated Security=SSPI;" & _ ! "Persist Security Info=False;" ! Else ! conn.Connection.ConnectionString = _ ! "Data Source=" & m_serverName & ";" & _ ! "Initial Catalog=" & m_name & ";" & _ ! "Integrated Security=false;" & _ ! "Persist Security Info=False;" & _ ! "User Id=" & m_user & ";" & _ ! "Password=" & m_password ! conn.Connection.Open() ! End If Catch ex As SqlClient.SqlException Throw New DatabaseConnectionException(ex.Message, ex) |