944,014 Members | Top Members by Rank

Ad:
  • ASP.NET Discussion Thread
  • Unsolved
  • Views: 1235
  • ASP.NET RSS
May 10th, 2007
0

MS Access connections

Expand Post »
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.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Light Poster
DeOiD is offline Offline
30 posts
since Apr 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in ASP.NET Forum Timeline: validating control in agridview
Next Thread in ASP.NET Forum Timeline: help with detals view, looking up data from another table





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC