Home > Visual Studio > Visual Studio 2010 Access Database Unspecified Error

Visual Studio 2010 Access Database Unspecified Error

A combination of new drivers and dumb luck! –John Galt Apr 15 '13 at 12:10 Follow-up: the problem persisted; however, I believe the real issue is a conflict with Paul ~~~~ Microsoft MVP (Visual Basic) No, running as normal user.Peter Tuesday, August 23, 2011 1:03 PM Reply | Quote 0 Sign in to vote Where is the database located? Is it in a Documents folder? If I try to add a database on the App_Data folder and open it, I get the same error. have a peek here

What is the purpose of the box between the engines of an A-10? When the program iterates through the records, and makes the changes, it will eventually get this error: A first chance exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll Unspecified error here's my At the very least, you should have the following line in every Catch block: Code: Debug.WriteLine(oException.ToString()) You'll then get some useful information in the Output window when the exception is caught. Integer function which takes every value infinitely often Sending a stranger's CV to HR Are there textual deviations between the Dead Sea Scrolls and the Old Testament? http://stackoverflow.com/questions/16004259/visual-studio-vb-net-database-explorer-unspecified-error

Interlace strings Another word for something which updates itself automatically Positional Bathroom Etiquette Has there ever been a sideways H-tail on an airplane? And again after rebinding the projects. This includes setup projects and any database projects not created using SSDT.

I think there isn't need to open the connection by yourself. ------------------------------------------ The Fill method retrieves the data from the data source using a SELECT statement. Not sure what causes the errors though. When the connection is made, the Microsoft Jet OLE DB creates temporary files in the Temp folder in the following directory: Document and Settings\ServerName\ASPNET\Local settings where ServerName is the name of Thank you for all of your help.Peter Wednesday, August 24, 2011 1:51 AM Reply | Quote Microsoft is conducting an online survey to understand your opinion of the Msdn Web site.

In Windows Explorer, locate the following folder: Document settings\ServerName\ASPNET\Local settings\Temp where ServerName is the name of your server. 2. Very strange indeed. I have searched here, read MSDN, reinstalled Visual Studio, but nothing seems to work. http://stackoverflow.com/questions/9203077/access-2010-database-with-visual-studio-2010 Friday, August 17, 2012 4:14 PM Moderator 0 Sign in to vote I've tried attaching to VS (admittedly, only when I was running the RC) - but got no exception details

Here's what i posted: I have been given a task to normalize a table. For example, the following lines of ASP code :strCN = "DRIVER={Microsoft Access Driver (*.mdb)};" & _ "DBQ=C:\Inetpub\wwwroot\App_Data\example.mdb" Set objCN = Server.CreateObject("ADODB.Connection") objCN.Open strCN ' <-- Note: ASP Error Occurs Here strSQL I have tried to compact and repair the database, but that does not help. Contact Us Privacy Policy Terms & Conditions About Us ©2016 C# Corner.

Browse other questions tagged database visual-studio-2010 ms-access or ask your own question. Any way, there isonly one 2012 versionof Visual Studio. The worst part is the fact it gives you no explanation and I haven't found a way yet to determine what is causing it. It seems that in some instances some SQL Server DLLs will replace the ones expected by VS and will cause strange behaviour: [Visual Studio Database Tools Error][social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/‌… on MSDN forums. –Renaud

It would probably save lots of time and heartache into the future. –JcMaltaDev Dec 28 '10 at 14:28 Hello. navigate here the error pops after about the 20th iteration. Additionally when you open the solution the first time you'll get an upgrade log. In the Authentication Methods dialog box, click to select the Anonymous Access check box.

This occurs frequently when you're using project types that shipped after VS 2010. Join them; it only takes a minute: Sign up Access 2010 database with Visual Studio 2010 up vote 2 down vote favorite I have an Access 2010 database that I am Otherwise I got installation errors. http://gmailpush.com/visual-studio/visual-studio-2010-unspecified-error-css.html I have also Visual Studio 2005 installed on the same machine.

BUT, after unbind all projects i had to quit visual studio. The content you requested has been removed. Create a new Microsoft Visual C# .NET or a new Microsoft Visual Basic .NET ASP.NET Web Application.

Have a nice day.Alan Chen[MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and

Basically, I have been connecting to an Access Database through Visual Studio for some time now (there is a reason why I am using Access Database), but all of the sudden A better solution would be to move the Access database out of your Web site's content area to a folder where the application pool's impersonated identity has read/write permission, then create Right-click the Temp folder, and then click Properties. 3. To do this, follow these steps: a.

Latest Blogs Create Pagination, Sorting, Filter With HTML Table Using DataTable.JS Exporting Excel With Multiple Sheets To Data set C# Corner Wishes You A Happy and Prosperous Diwali Multi Step Form Your ASP code would then reference the System DSN in the connection string instead of the physical path of the database, which is also better for security. STATUS This behavior is by design. this contact form I was told that the updating many records would cause this problem but using a Select/Insert Into statement would fix it.

Silverlight version: 5. Advanced Search VBForums Visual Basic Visual Basic .NET [RESOLVED] Access: Unspecified error If this is your first visit, be sure to check out the FAQ by clicking the link above. asked 5 years ago viewed 2099 times active 5 years ago Blog Stack Overflow Podcast #93 - A Very Spolsky Halloween Special Get the weekly newsletter! Thanks, Kieron Proposed as answer by b33rdy Monday, August 20, 2012 1:21 PM Marked as answer by Mukminoff Wednesday, August 22, 2012 8:44 AM Monday, August 20, 2012 11:43 AM 0

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! You should look at the log to see what errors were generated. We hope it gets fixed in RTM. I would like to mainly to take advantage of the EF 4.

Monday, August 20, 2012 3:40 PM 0 Sign in to vote I noticed some additional IISExpress properties. One other suggestion, make sure to close your connection when you're finished with the database operation.