Feb 16, 2009
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 : close Access,close VS, open VS,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 ?
View 1 Replies