Unspecified Error in IDE when Access is opened

Unspecified Error in IDE when Access is opened

Post by easoftwar » Wed, 18 Feb 2009 13:48:16


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 nspecified 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 ailed to open a connection to the database
nspecified 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 ailed to open
a connection to the database nspecified 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 esetVS ?

Thanks
 
 
 

Unspecified Error in IDE when Access is opened

Post by Paul Shapi » Fri, 20 Feb 2009 04:51:19

Any chance Access is defaulting to opening the db exclusively?



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 nspecified 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 ailed to open a connection to the database
nspecified 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 ailed to open
a connection to the database nspecified 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 esetVS ?

 
 
 

Unspecified Error in IDE when Access is opened

Post by easoftwar » Sat, 21 Feb 2009 08:18:27

On Feb 18, 11:51m, "Paul Shapiro" < XXXX@XXXXX.COM >



> In VS I try to configure the OleDbDataAdpater, I right click on it an>
> get the Data Adapter Configuration Wizard window, in the Choose you>
> Data Connection pane, I select my database, and I get ailed to ope>
> a connection to the database UnspecifiedErrorheck t>e
> connection and try agai>.gt; >
> If I run/debug my app, the data loads just fine. o I know the d>ta
> is not messed up, and the connection is OK. just have problems w>en
> I am designing in VS 2008 and after I have opened Access 2003. > I
> close Access, the problem does not go aw>y.> >
> To get the problem to go away, I need t> :
> close Acc>ss,
> clos> VS,
> op>n VS,
> load a new p>oject,
> Add a new Data Source to the new >roject,
> re-open my>pr>ject.
>
> What is happening? s there a better way to esetVS ?

I do not think so.

1) When I run my app, the app still retrieves the data
2) I made a small test project, (just one form, one OleDbDataAdpater,
one DataGrid) and it works just fine.
 
 
 

Unspecified Error in IDE when Access is opened

Post by easoftwar » Sun, 22 Feb 2009 02:31:59

On Feb 18, 11:51m, "Paul Shapiro" < XXXX@XXXXX.COM >


I do not think so

1) When I run my app, all the data loads fine. It is just in the VS
2008 IDE where I have problems.

2) I have made a small test project in VS 2008, and I have no problems
with the test app.
 
 
 

Unspecified Error in IDE when Access is opened

Post by easoftwar » Sun, 22 Feb 2009 13:12:10


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.

3) I tested with VS 2008, VS 2003 and Access 2003 open. I was able to
modify the OleDbDataAdpaters in VS 2003, but not in VS 2008 (using the
same Access database).

On Feb 18, 11:51m, "Paul Shapiro" < XXXX@XXXXX.COM >



> In VS I try to configure the OleDbDataAdpater, I right click on it an>
> get the Data Adapter Configuration Wizard window, in the Choose you>
> Data Connection pane, I select my database, and I get ailed to ope>
> a connection to the database UnspecifiedErrorheck t>e
> connection and try agai>.gt; >
> If I run/debug my app, the data loads just fine. o I know the d>ta
> is not messed up, and the connection is OK. just have problems w>en
> I am designing in VS 2008 and after I have opened Access 2003. > I
> close Access, the problem does not go aw>y.> >
> To get the problem to go away, I need t> :
> close Acc>ss,
> clos> VS,
> op>n VS,
> load a new p>oject,
> Add a new Data Source to the new >roject,
> re-open my>pr>ject.
>
> What is happening? s there a better way to esetVS ?