Dim ConnectionString As String = "Data Source=LANSWEEPER\SQLEXPRESS;Initial Catalog=lansweeperdb;User ID=sa;Password=MYsaPASSWORD;Connect Timeout=30" Dim Connection As New System.Data.SqlClient.SqlConnection(ConnectionString) Dim command As New System.Data.SqlClient.SqlCommand("SELECT a.Username, a.ComputerUnique, c.softwareName, c.softwareVersion, c.SoftwarePublisher FROM dbo.tblComputers a RIGHT JOIN dbo.tblUsers b ON b.Computername = a.Computername JOIN dbo.tblSoftware c ON c.Computername = a.ComputerName WHERE a.ComputerUnique = CORP\" & My.Resources.ComputerName & "\1", Connection)
Dim ConnectionString As String = "Data Source=\\\\LANSWEEPER\\SQLEXPRESS;Initial Catalog=lansweeperdb;User ID=sa;Password=MYsaPASSWORD;Connect Timeout=30"
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)