hi
i have another problem with my DB... until yesterday everthing worked fine but suddenly the entire project stoped working.
i use this method to connect to the data base: Imports System.Data.OleDb ...
Public Class func
Public Shared Function seleccionar(ByVal comando As String)
Dim DBliga As OleDbConnection
Dim DBcomando As OleDbCommand
DBliga = New OleDbConnection(connect)
DBliga.Open()
DBcomando = New OleDbCommand(comando, DBliga)
seleccionar = DBcomando.ExecuteReader()
End Function
End Class and to call the function i use:
Dim DBdatareader As OleDbDataReader
DBdatareader = func.seleccionar("select * from contactos") well, like i said, this worked fine until yesterday but today, without changing anything, when the function is called a second time i get this error System.Data.OleDb.OleDbException and erro não especificado (something like error not specified ) here DBliga.Open() i can't close the connection because i need to use the datareader...
can anyone help me?