[RESOLVED] Unable to connect to MS SQL express

[Alfarata]

I have used to code from a YouTube VB.Net Tutorial and I cannot connect. I am using Microsoft Visual Studio Community 2017 and Micosoft SQL Server Management Studio V17.7. I have checked the code But have been unable to see the problem Here is the code and the error message

 Imports System.Data.SqlClient

Public Class SQLControl
    Private DBCon As New SqlConnection("Server= BILLS_LAPTOP\SQLEXPRESS01:Database = Maint1;User = Maint1:Pwd = Password1;")
    Private DBcmd As SqlCommand
    'BILLS_LAPTOP\SQLEXPRESS01
    ' DB Data
    Public DBDA As SqlDataAdapter
    Public DBDT As DataTable


    ' Qury Parameters
    Public Params As New List(Of SqlParameter)

    'Query Statistics
    Public RecordCount As Integer
    Public Exception As String

    Public Sub New()

    End Sub
    'Allow Connection String Override
    Public Sub New(ConnectionString As String)
        DBCon = New SqlConnection(ConnectionString)
    End Sub
    'Execute Query Sub
    Public Sub ExecQuery(Query As String)
        'Reset Query Stats
        RecordCount = 0
        Exception = ""
        Try
            DBCon.Open()

            'Creat DB Command
            DBcmd = New SqlCommand(Query, DBCon)

            'Load Parans into DB Command
            Params.ForEach(Sub(p) DBcmd.Parameters.Add(p))
            'Clear Param List
            Params.Clear()

            'Execute Command & Fill Dataset
            DBDT = New DataTable
            DBDA = New SqlDataAdapter(DBcmd)
            RecordCount = DBDA.Fill(DBDT)

        Catch ex As Exception
            'Capture Error
            Exception = "ExceQuery Error: " & vbNewLine & ex.Message


        Finally
            'Close Connection
            If DBCon.State = ConnectionState.Open Then DBCon.Close()


        End Try
    End Sub
    'Add Params
    Public Sub AddParam(name As String, value As Object)
        Dim NewParam As New SqlParameter(name, value)
        Params.Add(NewParam)
    End Sub

    'Error Checking
    Public Function hasexception(Optional Report As Boolean = False) As Boolean
        If String.IsNullOrEmpty(Exception) Then Return False
        If Report = True Then MsgBox(Exception, MsgBoxStyle.Critical, "Exception:")
        Return True

    End Function


End Class

Thanks for any help you can give me. I am new to both VB2017 and SQL DB's

[OptionBase1]

I won't attempt to assist beyond this single reply, because there are so many potential issues that can be at play here that are nearly impossible to diagnose over forum posts without a tremendous amount of repeated "did you check this?"

That being said, the screenshot seems to indicate that your database name is "HiTech", but your connection string seems to be attempting to connect to a database called "Maint1"

[Alfarata]

Sorry I was doing editing and made a mistake I changed it back to HiTech And got the Same error as before I started editing.

Thanks

[Zvoni]

Is it the colon instead of semicolon?
https://www.connectionstrings.com/sq...rver-instance/

_LAPTOP\SQLEXPRESS01:Database =
:Pwd =

[Alfarata]

Thanks
I missed that but changing it did not help I still get the same error

Thanks

[Alfarata]

Ops I missed the first : I changed it and now I get this error.




Thanks for finding some of this But I have never used Mssql before yesterday.

[jdc2000]

Try this:

Private DBCon As New SqlConnection("Server=BILLS_LAPTOP\SQLEXPRESS01;Database=Maint1;User=Maint1;Pwd=Password1;")

[Alfarata]

Same error
The Database is named HiTech I don't know what other information to give to you folks to help me


Thanks

[jdc2000]

Try it without the last semicolon. The error indicates that the password is incorrect.

[Alfarata]

Well that also did nothing different than the last error message

[jdc2000]

Can you log in to SQL Server Management manually using the same credentials you are using in the connection string?

[Alfarata]

No I had been logging with my Windows Authorization here's the 2 screens and the errors



I'm days new to MSSQL
not sure how to fix this from Here

Thanks

[jdc2000]

Possibly useful links:

https://docs.microsoft.com/en-us/sql...ql-server-2017

https://www.papercut.com/support/res...ql-server.html

[Alfarata]

Thank for everyones help it was the SQL's login type to be setup
Thanks
Alfarata