PGlabo

« [ASP.NET] ViewState と Session | メイン | [ASP.NET|SQL Server] SQL Server に接続 »

2005年10月06日

[ASP.NET|SQL Server] SQLServer認証 と WINDOWS認証

        Dim Conn As New System.Data.SqlClient.SqlConnection
        Dim strConn As String

        If Type = "SQLServerSQL" Then

            '▼SQLServer認証▼

            strConn = "Persist Security Info=True;" & _

                            "database=master;" & _

                            "server=localhost;" & _

                            "User=sa;" & _

                            "Password=;"

        ElseIf Type = "SQLServerWIN" Then

            '▼WINDOWS認証▼

            strConn = "Integrated Security=SSPI;" & _

                            "Persist Security Info=False;" & _

                            "Initial Catalog=master;" & _

                            "Data Source=hocalhost;"

        End If

        Conn.ConnectionString = strConn

2005 / 10 / 06