1,105,581 Community Members

InvalidOperationException was unhandled

Member Avatar
YungSoprano
Newbie Poster
9 posts since Aug 2011
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Hi everyone,
I'm creating a booking application for a hotel and have encountered an error on the following code;

Public Class Seaside_Hotel_DB
    Dim dbconn As OleDb.OleDbConnection
    Dim dbcmd As New OleDb.OleDbCommand
    Dim dbread As OleDb.OleDbDataReader
    Dim spath As String
    Public Sub New()
        spath = Application.StartupPath
        spath = spath.Replace("\bin\Debug", "")
        spath = spath + "\Seaside Hotel.mdb"
        dbconn = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & spath & ";Persist Security Info=True")
    End Sub
    Public Function NewClient(ByVal cname As String, ByVal adr As String, ByVal city As String, ByVal pcode As Int32, ByVal phone As String) As Boolean
        Dim query As String
        Try
            dbconn.Open()
            query = "insert into Customer (CustName,Address,City,PostCode,Phone) values ('" & cname & "','" & adr & "','" & city & "'," & pcode & ",'" & phone & "')"
            dbcmd = New OleDb.OleDbCommand(query, dbconn)
            dbcmd.ExecuteNonQuery()
            dbconn.Close()
            Return True
        Catch ex As OleDb.OleDbException
            Return False
        End Try
    End Function

The error is the dbconn.open() in the public function New Client.

Your assistance will be appreciated.

Many thanks

Member Avatar
catherine sea
Junior Poster
126 posts since Jan 2008
Reputation Points: 15 [?]
Q&As Helped to Solve: 22 [?]
Skill Endorsements: 0 [?]
 
0
 

Hi Yung,

What is the error message?

Member Avatar
ntzfx
Newbie Poster
1 post since Jun 2010
Reputation Points: 0 [?]
Q&As Helped to Solve: 1 [?]
Skill Endorsements: 0 [?]
 
1
 

This error may relate to which excel edition you use or you can choose another provider instead "Microsoft.Jet.OLEDB.4.0"

Member Avatar
GeekByChoiCe
Master Poster
701 posts since Jun 2009
Reputation Points: 152 [?]
Q&As Helped to Solve: 170 [?]
Skill Endorsements: 3 [?]
Featured
 
0
 

Your database path setup looks a bit odd.
do a

MsgBox(dbconn.DataSource)

just before the dbconn.open() command and see if the database is stored at the path that is shown in the messagebox.

Member Avatar
Al-zene
Newbie Poster
1 post since Sep 2010
Reputation Points: 0 [?]
Q&As Helped to Solve: 1 [?]
Skill Endorsements: 0 [?]
 
1
 

Try to put your database in the same location as your application and run it again.

Member Avatar
Begginnerdev
Veteran Poster
1,142 posts since Apr 2010
Reputation Points: 251 [?]
Q&As Helped to Solve: 191 [?]
Skill Endorsements: 15 [?]
 
1
 
OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & spath & ";Persist Security Info=True")

Your connection string might be incorrect, it looks like it is missing some things.

Here is a good reference for connection strings:

http://www.connectionstrings.com/excel

Member Avatar
YungSoprano
Newbie Poster
9 posts since Aug 2011
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Thanks everyone, the app is good to go.

Question Answered as of 2 Years Ago by ntzfx, Al-zene, catherine sea and 2 others
You
This question has already been solved: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: