Cannot interact with Access database [Resolved]

[albertlse]

P/S: Please refer to the attachment for the error message that pops up!

My situation and problems:
I created an Installer for my VB.NET project. This program interacts with a database in Microsoft Access format. I built this program on Windows XP Professional Edition with Microsoft Visual Studio .NET.

At first, I installed Microsoft .NET Framework 1.1. When I install this program using the Installer on a Windows XP Home Edition PC, it works fine but cannot interacts with the database. Please refer to the attachment for the error message that pops up.

This PC does not has Microsoft Access. So I installed Microsoft Data Access Components 2.7 SP1. I tought it will works fine but it still cannot interacts with the database.

So I installed Microsoft Access XP. This also did not solved the problem.

For your information, this PC is a new one, with only the following softwares installed:
Windows XP Home Edition
Windows .NET Framework 1.1
Windows Data Access Componenets 2.7 SP1
Microsoft Access XP

Question 1:
How can I solve this problem? Is there any software that I need to installed for my program to interact with the Access database?

Question 2:
What is the purpose of Microsoft Data Access Components? Is it used to interact with Access database file without installing Microsoft Access?

Question 3:
If my program will to interact with Microsoft Access database file, does the PC that runs this program must have Microsoft Access installed? Is there any alternative?

I'm looking forward for answers of my questions. Please guide me. Thank you!

P/S: Please refer to the attachment for the error message that pops up!

[DevGrp]

Is the DB on the same PC with the program or is the DB on another PC on the network?

[Edneeis]

Whats the code on and around line 297 of frmPrintReport?

[albertlse]

The database is on the same PC.

Line 297 is inside the following function:

Private Sub subFillcboReportCode()
        Try
            'Open database connection
            ReportConnection.Open()

            'Clear ReportDataSet from last operation
            ReportDataSet.Tables.Clear()

            'Create SQL query to find Client Listing Code / Invoice Number
            ReportDataAdapter.SelectCommand.CommandText = _
                "SELECT " & strReportType & " " & _
                "FROM " & strDatabaseTable & " " & _
                "WHERE " & strDatabaseTable & "Date LIKE " & Chr(34) & strReportDate & Chr(34) & " " & _
                "ORDER BY " & strReportType

            'Fill ReportDataSet with rows resulting from query
            ReportDataAdapter.Fill(ReportDataSet)

            'Add ReportDataSet to cboReportCodeFrom & cboReportCodeTo
            'Set dataTable
            Dim dataTable As DataTable = ReportDataSet.Tables(0)

            'Ensure dataTable not empty
            If dataTable.Rows.Count <> 0 Then
                'Retrieve total row in dataTable
                Dim intTotalRow As Integer = dataTable.Rows.Count

                'Clear items in cboReportCodeFrom & cboReportCodeTo
                cboReportCodeFrom.Items.Clear()
                cboReportCodeTo.Items.Clear()

                'Add entries into cboReportCodeFrom & cboReportCodeTo
                Dim intCounter As Integer
                For intCounter = 0 To intTotalRow - 1
                    cboReportCodeFrom.Items.Add( _
                            Convert.ToString(dataTable.Rows(intCounter)(0)) _
                            )

                    cboReportCodeTo.Items.Add( _
                        Convert.ToString(dataTable.Rows(intCounter)(0)) _
                        )
                Next

            Else
                'Clear items in cboReportCodeFrom & cboReportCodeTo
                cboReportCodeFrom.Items.Clear()
                cboReportCodeTo.Items.Clear()
            End If

            'Close database connection
            ReportConnection.Close()

            'Display verbose information with database exception
        Catch oleDbExceptionParameter As System.Data.OleDb.OleDbException
            MessageBox.Show(oleDbExceptionParameter.ToString, Me.Text, MessageBoxButtons.OK, MessageBoxIcon.Error)

            'Display message box when invalid operation
        Catch invalidOperationExceptionParameter As InvalidOperationException
            MessageBox.Show(invalidOperationExceptionParameter.Message, Me.Text, MessageBoxButtons.OK, MessageBoxIcon.Error)
        End Try
    End Sub

when I run this program in my PC which I used to develop it, all fine, no problem / error.

but when I installed it on the new PC, then got this error.

please guide me. thank you.

[Edneeis]

Are you sure the connection string is correct? Any paths change or anything moving to the new pc? Which line is 297? The Fill method?

[albertlse]

Everything is correct.

Line 297 is:

ReportDataAdapter.Fill(ReportDataSet)

Let me make myself clear again:

I developed this program "Invoice System" on PC-A. Everything is fine. I also created an Installer for this program.

I used the Installer to install "Invoice System" on PC-B. PC-B is a new PC, only has Windows XP Home Edition, Microsoft Access. After installing "Invoice System", I can open the program. But, it cannot interact with the database. Why? The error message is attachment on my 1st posting, please check it out.

Am I clear? How can I solve this problem? It seems like, for example, Microsoft developed Office, and works well on their PC. But when I install Office on my PC, then got problem...

Hope u guys can help me. Thank you.

[Edneeis]

You were clear the first time. Have you tried running a simple 'SELECT * FROM MyTable' query from a compiled exe on PC - B? Is the problem really that it can't interact at all with a database or is it just that query on PC - B that doesn't work for some reason? Also when you installed on PC - B did you have administrative permissions on it? Are the parameters in the query the same on both machines (the values for strReportType, strDatabaseTable)?

Office is NOT needed to interact with an Access database, at least not in the method you are using.

[Lunatic3]

Look here. It may address your problem.
http://support.microsoft.com/default...NoWebContent=1

[gearbolt]

Did Lunatic solution work for you. If not are you willing to upload your code so we can try it.

Later

[ggprogram]

I think you should try a simple select command in place of the one you have, as someone has suggested.

This piece looks suspicious:

"WHERE " & strDatabaseTable & "Date LIKE "

Do you want the tablename there? and does it need a space before Date?

[Edneeis]

Date may also be a keywork and as such should be enclosed in [], but I think you said it ran fine on PC - A so I guess it can't be the code. The only thing I can think of is a Permissions problem or most likely what Lunatic posted. Good catch by the way, Lunatic.

[Lunatic3]

Originally posted by Edneeis
Good catch by the way, Lunatic.

Long live Google!

[nemaroller]

Google is like the 2nd best development aid beside the computer you're developing on...

[albertlse]

Thanks Lunatic3 and gearbolt and everyone, i think is the database file itself that cause problem. every thing is working fine now...