Hello,
I'm new to .net, so this may be a really easy question....I have been
working on a .net application - each web page pulls information from a an
access database and writes it to the screen. Mostly this is done using a
command object and a datareader. The data can also be edited - also using a
command object and the executenonquery method. There is one page that uses a
repeater.
This works fine with no errors until you have viewed and updated a number of
pages, when it throws an error:
[OleDbException (0x80004005): Unspecified error]
System.Data.OleDb.OleDbConnection.ProcessResults(I nt32 hr) +20
System.Data.OleDb.OleDbConnection.InitializeProvid er() +57
System.Data.OleDb.OleDbConnection.Open() +203
templates.template2_21.getData(String sSQL) in
c:\inetpub\wwwroot\templates\template2_2.ascx.vb:1 35
templates.template2_21.getSiteValues() in
c:\inetpub\wwwroot\templates\template2_2.ascx.vb:2 02
templates.template2_21.Page_Load(Object sender, EventArgs e) in
c:\inetpub\wwwroot\templates\template2_2.ascx.vb:3 39
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Page.ProcessRequestMain() +750
The stack trace is:
System.Data.OleDb.OleDbException: Unspecified error
I have set the command objects to nothing after I've finished with them, but
I was wondering if there was something else in this vein that I need to
do....any help would be much appreciated!!