Hi Anthony,
I'm sorry wasn't able to post the full detail of my question earlier, so here it goes. The application is running in a USB Flash Disk which we developed in which the system returns a certain specific error that we can't resolve as of this moment, the error usually occur in a oledbconn.open(), i tried to ask one of our senior application developer regarding this matter and we've tried to connect and create a global function in which the database location will be directly directed but the error always occur this way. At the earlier stage of development we did not encounter this problem because we only run a soft run of the application, but when we tried to stress test the system. It always return the "unspecified error". Is this because of the bulk data entered in the application?we are currently using a grid to view, add, update all the necessary items that is needed.
By the way here is the code for the database connection that we have created earlier
Public DatabasePath = Apppath & "\MyDB.mdb;"
Public ConnString As String = _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & DatabasePath & "" & _
"Persist Security Info=False;Jet OLEDBatabase Password=13Tm3in[]$;"
and here is the code in which we created a tab for the categories of each items:
Try
'Initialize datagrid
Dim OleDbConn As OleDbConnection = New OleDbConnection(ConnString)
OleDbConn.Open()
Dim dsInfox As DataSet = New DataSet()
Dim MyOleDataAdapter As OleDbDataAdapter = New OleDbDataAdapter()
MyOleDataAdapter.SelectCommand = New OleDbCommand(Sqlstring, OleDbConn)
dsInfox.Clear()
MyOleDataAdapter.Fill(dsInfox)
If dsInfo IsNot Nothing Then
If dsInfox.Tables(0).Rows.Count > 0 Then
Return True
Exit Function
Else
Return False
End If
End If
OleDbConn.Close()
Catch ex As Exception
MsgBox(ex.ToString)
'ProcessErrorMessage(ex.Message.ToString & ex.GetBaseException.ToString, "LoadAllStudInfo() Exception")
End Try
By the way here is just one of the so many functions that we created that returns the error "unspecified error"
Hope u can help me solve this problem cause we badly need it
Thanks in advance
