Home > How To > How To Solve Unspecified Error In Vb.net

How To Solve Unspecified Error In Vb.net

Member 532 Points 171 Posts Re: System.Data.OleDb.OleDbException: Unspecified error Oct 29, 2007 03:11 AM|[email protected]|LINK May be your folder is hidden goto tools->folder options ->view->hidden files and folders->enable show Krishna Accottillam All times are GMT -5. Finally, if an exception is thrown your command isn;t going to get disposed. On Friday, my code was working just fine, but come Monday morning I'm now receiving this error on the "dataAdapter.Fill(dataset)" every time I try to read Excel into a dataset using Source

When are you sending Command objects through? the connection string via Connection Strings Website[^] 2. http://www.codeproject.com/KB/aspnet/EasyADODgrids.aspx[^] http://www.codeproject.com/KB/database/databinding_tutorial.aspx[^] http://www.codeproject.com/KB/XML/CreateXMLDB.aspx[^] Good luck! this has to do with impersonation. page

Reply hans_v All-Star 25736 Points 7017 Posts Re: [solved] System.Data.OleDb.OleDbException: Unspecified error Feb 02, 2013 04:50 PM|hans_v|LINK Decker Dong - MSFT Compared with this, I think SQL can let us access C# forum discussion How to Make Default Button? For whatever reason, this would allow access. 5) Deleted database and dataset that were added to solution expolorer 6) Went back to Database Explorer and everything is working fine again! error in web.config (attaching the error image) though I fix it I do not understand why it appears / displaying the error using the MS Access as database Please help its

Solution 4 Accept Solution Reject Solution You're creating a new connection to the database, starting a DataReader, but you're never closing the connection when you're done with the DataReader. Thanks for your help. -Jerry "W.G. What happens if one brings more than 10,000 USD with them into the US? I have now managed to sych the threads so that I close some before opening too many.

Does the ASP application have read permissions over the folder that the file is in? So, whats causing this? In my investigation I found that all 3 of the below work (ie the 120ish cycles occur with no errors) - but clearly the first 2 are for debug only Solution The sqlnet.log doesn't tell too much Here is my code..

So replace it with "myCommand.CommandText ="selectmy_table.FirstName From my_table"" Adamus Sunday, July 09, 2006 11:23 PM Reply | Quote 0 Sign in to vote I tried to trace it, (enabling trace option Solution 3 - WORKS) Replaced the RTB update with the line Threading.Thread.Sleep(15). Posted 7-Nov-10 21:08pm jack_th1.4K Add a Solution 4 solutions Top Rated Most Recent Rate this: Please Sign up or sign in to vote. Rate this: Please Sign up or sign in to vote.

Reply hans_v All-Star 25736 Points 7017 Posts Re: [solved] System.Data.OleDb.OleDbException: Unspecified error Feb 01, 2013 06:56 AM|hans_v|LINK barmajiat Do you mean that I should not use Access database for web applications https://support.microsoft.com/en-us/kb/825738 Reply Decker Dong... The content you requested has been removed. Reply barmajiat None 0 Points 8 Posts Re: [solved] System.Data.OleDb.OleDbException: Unspecified error Jan 28, 2013 01:55 PM|barmajiat|LINK Dear Dong, Here is my problem, I have an Access2010 database split into FE&BE.

I don't know if there is something significant about opening 65 connections. this contact form It was not solely related to the conflict with an SQL instance; even after I had "resolved" this issue, I would continue to receive an "Unspecified Error". I reviewed all my asp codes and found a couple ofDataReader and database connectionthat were not closed immediately. but later i created only one conn object instance globally and used to open n close it as and when required.

Each one specifies a connection to the same database. Visit our UserVoice Page to submit and vote on ideas! This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL) Top Experts Last 24hrsThis month Suvendu Shekhar Giri 123 Midi_Mick 120 http://upintheaether.com/how-to/how-to-solve-b37-error.php I am starting up a number of threads.

the error msg thrown by the catch : (logged in a text file) Source : Microsoft JET Database EngineMethod : ProcessResultsDate : 3:30:07 PMTime : 4/13/2006Error : Unspecified errorStack Trace : And what's more, compared with SQL, Access isn't easy to control with problems such as concurrency…… So if possible, SQL Express is still a good choice. I also suggest you consider the 2nd part as well.

Solution 3 Accept Solution Reject Solution Here are detial of the error: System.Data.OleDb.OleDbException was unhandled by user code ErrorCode=-2147467259 Message="Unspecified error" Source="Microsoft JET Database Engine" StackTrace: at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions

you can go to the temp folder ( ex. Try Dim strConnectionString as string Dim myCommand As new ADODB.CommandDim myRecordset As new ADODB.RecordsetDim MyConn as new ADODB.Connection  strConnectionString = "Driver={Microsoft ODBC for Oracle};Server=" & SID & ";UID=" & User & ";PWD=" Only use action query's to modify or delete data, only use disconnected recordsets.... All-Star 94122 Points 18125 Posts Re: [solved] System.Data.OleDb.OleDbException: Unspecified error Feb 01, 2013 08:38 PM|Decker Dong - MSFT|LINK hans_v The problems occur when a user opens arecordset, then one or more

Thank you very much! At which statement the error is thrown out? Alternatively just tell us what you think!

Web Development ASP.NET Quickstart Programming news Java programming ASP.NET tutorials C# programming Developer Jobs ASP.NET Jobs Java Jobs Developer Jobs Our tools We've http://upintheaether.com/how-to/how-to-solve-ssl-error-61.php But fo you consider this a good practice?

It is not file specific either, it is happening to all. Salary A Simple Custom Control (focussed TextBox) Using recursion to create a program to backup folders Idustrial process regulation using a VB.NET PID controller Exploring DataGridView (ComboBox, Checkbox, Increment, BindingSource) Exploring