MS Access connections

Reply

Join Date: Apr 2007
Posts: 30
Reputation: DeOiD is an unknown quantity at this point 
Solved Threads: 0
DeOiD DeOiD is offline Offline
Light Poster

MS Access connections

 
0
  #1
May 10th, 2007
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?
Last edited by DeOiD; May 10th, 2007 at 11:22 am.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the ASP.NET Forum


Views: 1143 | Replies: 0
Thread Tools Search this Thread



Tag cloud for ASP.NET
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC