SQLServer Connection

Private lSqlDatabase As New SqlClient.SqlConnection

‘ SQL SERVER Connect
lSqlDatabase.ConnectionString = GetConnectionString()

Private Function GetConnectionString() As String
Dim strConnectionString As String

‘ Data Source =サーバー名
‘ Database = データベース名
‘ User=ユーザー名
‘ Password=パスワード
‘Connection timeout=タイムアウトの設定(秒)

strConnectionString = “Data Source=” & lServerName & “;” & _
“Database=” & lDatabaseName & “;” & _
“User=” & lUserName & “;” & _
“Password=” & lUserPassword & “;” & _
“Connection timeout=” & CMD_TIMEOUT &”;”

Return strConnectionString
End Function

タイトルとURLをコピーしました