help please

[et_]

Ive visited connectionstrings.com and tried all the oledb options, but none have worked out. Either i get a named pipes error, or can not connect error.
Im using sql server 2005 express.

my code:

Testing Class
Public Class Form1
    Public WithEvents test1 As GenSchema

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim dsPath As String = "C:\Documents and Settings\Administrator\Desktop\db\SignMaker_Data.MDF"
        Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" _
        & "Data Source= " & dsPath & ";" _
        & "Persist Security Info=False"
        Dim strConn As String = _
                "Provider=SQLNCLI;Server=BORAT\SQLEXPRESS;Database=SignMaker;Trusted_Connection=yes;"
        test1 = New GenSchema(strConn)
    End Sub

    Public Sub statChange(ByVal connectionStatus As GenSchema.dbStat) Handles test1.evStatus
        MsgBox(connectionStatus.ToString)
    End Sub

End Class

Connection class
Public Class GenSchema
    
    Public Enum dbStat
        closed
        open
        disposed
        openError
    End Enum

    Public connectionStatus As dbStat
    Public Event evStatus(ByVal connectionStatus As dbStat)

    Public Sub New(ByVal strConnPath As String)
        Open a connection object
        Dim oleConn As OleDb.OleDbConnection = Nothing
        Try
            openConnection(oleConn, strConnPath)
        Catch ex As SqlClient.SqlException
            Console.WriteLine("crap, " & ex.Message.ToString)
            connectionStatus = dbStat.openError
            RaiseEvent evStatus(dbStat.openError)
        Catch ex As Exception
            Console.WriteLine("crap, " & ex.Message.ToString)
            connectionStatus = dbStat.openError
            RaiseEvent evStatus(dbStat.openError)
        Finally
            oleConn.Close()
            connectionStatus = dbStat.closed
            RaiseEvent evStatus(connectionStatus)
            oleConn.Dispose()
            connectionStatus = dbStat.disposed
            RaiseEvent evStatus(connectionStatus)
        End Try
    End Sub

    Private Sub openConnection(ByRef oleConn As OleDb.OleDbConnection, ByVal strConnPath As String)
        oleConn = New OleDb.OleDbConnection(strConnPath)
        oleConn.Open()
        connectionStatus = dbStat.open
        RaiseEvent evStatus(connectionStatus)
    End Sub

End Class

 

[PlausiblyDamp]

Is the sqlexpress running on the same pc as your application? If not then be aware that SQLExpress only listens on the local pc by default and you will need to reconfigure it before network access is allowed.

Just out of curiosity is there a reason you are using OleDb rather than the SqlClient?

 

[et_]

I found a code example using oledb.

I guess ill try sqlclient, but im still curious why everytime i use oledb i get the following error:

Could not load file or assembly System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a or one of its dependencies. The system cannot find the file specified