Last post Feb 20, 2009 10:56 PM by easoftware
Feb 17, 2009 11:49 AM|easoftware|LINK
I was directed to this forum from the MSDN Forums, "Where is the forum for..." thread.
I am using VS 2008 Professional and connecting to an Access 2003 database. I have converted my app from VS 2003 to VS 2008. I have kept all the OleDbDataAdpaters. When designing, I like to have both VS and Access open, so I can see if my SQL queries and
other code load/edit/append/delete the data correctly.
The problem I am having, is once I open Access, I can no longer edit any of my database settings in VS. Examples:
In VS I open the Server Explorer, and see the database I am using. I double click on it, and I get the error message “Unspecified Error”.
In VS I try to add a DataSource. In the Data Source Configuration Window, in the Choose a Data Source Type pane, I select Database and click on Next. When I see Choose Your Data Connection, I select my database, and I get “Failed to open a connection to the
database “Unspecified Error” Check the connection and try again.”
In VS I try to configure the OleDbDataAdpater, I right click on it and get the Data Adapter Configuration Wizard window, in the Choose your Data Connection pane, I select my database, and I get “Failed to open a connection to the database “Unspecified Error”
Check the connection and try again.”
If I run/debug my app, the data loads just fine. So I know the data is not messed up, and the connection is OK. I just have problems when I am designing in VS 2008 and after I have opened Access 2003. If I close Access, the problem does not go away.
To get the problem to go away, I need to :
load a new project,
Add a new Data Source to the new project,
re-open my project.
What is happening? Is there a better way to “reset” VS ?
Feb 19, 2009 07:50 PM|hypercode|LINK
Feb 20, 2009 11:40 AM|easoftware|LINK
The Access database is not locked because:
1) When I run my app, it loads the data fine. I only have the problem in the Visual Studio IDE.
2) I made a small test project in VS 2008, and it works fine.
Feb 20, 2009 10:56 PM|easoftware|LINK
I tested with VS 2008, VS 2003 and Access 2003 open. I was able to modifiy the OleDbDataAdpaters in VS 2003, but not in VS 2008 (using the same Access database).