VB 2008 - What does this x mean?

In my program I am experiencing several database related problems.  If you look at the screenshot of the Database Explorer (attached) you will see a small red X next to the name of the database.

I don't know what that means but I am pretty sure it is not good.  Moreover, I do not know what to do about it.  Perhaps you have some suggestions.
error2.JPG
ljcorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kevin CrossChief Technology OfficerCommented:
The red x usually just signifies that connection is closed to that database.  Try right-clicking on 'Data Connections' and click refresh and see if it changes.  Or right-click that database in explorer and choose modify connection and ensure the authentication/information is correct and test connection.
0
Jorge PaulinoIT Pro/DeveloperCommented:
You can also try to right click in the Data Connections node and select Refresh
0
ljcorAuthor Commented:
I am baffled.  The Refresh does not change anything but it does continue to say "The path is not of a legal form."

 I did run Modify Connection a few minutes ago, for about the 5th time (really).  I "tested" the connection and it said it worked just fine.  But nothing changes.
0
PMI ACP® Project Management

Prepare for the PMI Agile Certified Practitioner (PMI-ACP)® exam, which formally recognizes your knowledge of agile principles and your skill with agile techniques.

ljcorAuthor Commented:
Additionally, when I Modify the connection I actually end up with exactly the same path that I have had all along.
0
Kevin CrossChief Technology OfficerCommented:
Does it actually work to view tables, etc. within the database?

What is the path by the way?
0
Jorge PaulinoIT Pro/DeveloperCommented:
Try to close VS, open it again, Modify the connection to the right path and save it.
0
ljcorAuthor Commented:
I closed the VB program completely, re-opened it, modified the connection.  The X went away.  However, I used DropTable to get rid of a table I do not want.  Nothing changed!  The table still existed in the Tables list.

So I then closed the project and re-opened it.  The X has returned and the table is still in the Tables list.

The path: C:\Documents and Settings\Jack Cory\My Documents\Visual Studio 2008\Projects\EvaluationProject\EvaluationProject\EvaluationDB.sdf

This is the same path that I have had for sometime.  If I load a backup copy I keep of the project from over a week ago, all of these items appear to be the same, including the path and the unused Table.
0
ljcorAuthor Commented:
Perhaps there is some other solution  OR  Is there a way to disconnect the Database and/or the DataSet from the project and then start over again?  However, I do not want to have to recreate the Database from scratch again unless I absolutely have to do so.  I do not even want to have to bind all of the controls again - unless I absolutely have to do so.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.