0

Hello, I'm a newbie working with vbnet but i'm trying to create a project were I enter a name in a textbox and save it to a access database.

I'm trying to create the OledbConnection but i'm getting this error:

"oleDbException was unhandled"

this is the code i'm using:

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        con = New OleDbConnection("provider=microsoft.jet.oledb.4.0; data source= pract.mbd")
        da = New OleDbDataAdapter("select*from emp", con)
        cb = New OleDbCommandBuilder(da)
        ds = New DataSet
        da.Fill(ds, "emp")
    End Sub

Thanks!!!!!

3
Contributors
4
Replies
5
Views
5 Years
Discussion Span
Last Post by Plantcode
0

Your file extension for the access database should be .mdb not .mbd I'd start there.
Also there should be no space after the semicolon. I also never have a space before or after my equal sign.

Try the following:

Dim con as New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=pract.mdb")

Edited by Phasma: Grammar

0

Maybe you have to write the full path to the database:

"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\Folder1\Folder2\LocalAccess40.mdb"
0

Put the following in your code window with the Imports System.Data.OleDb and run it maybe from the Form Load event.

Private Sub TEST()

    Dim con As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=pract.mdb")
    Try
      con.Open()
    Catch ex As Exception
      MsgBox(ex.ToString)
    Finally
      con.Close()

    End Try

  End Sub    End Try

If there is an exception, you will see it in the Message Box and be able to determine what is wrong.

0

Thanks! already tried with the code and the name of the database extension, that was the problem you were right, and now It is working perfectly so far! Thanks for the help again! :)

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.