Solved

VB 2008  - What does this x mean?

Posted on 2009-07-15
8
304 Views
Last Modified: 2012-06-21
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
0
Comment
Question by:ljcor
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
8 Comments
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 24857557
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
 
LVL 48

Expert Comment

by:jpaulino
ID: 24857565
You can also try to right click in the Data Connections node and select Refresh
0
 

Author Comment

by:ljcor
ID: 24857575
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:ljcor
ID: 24857585
Additionally, when I Modify the connection I actually end up with exactly the same path that I have had all along.
0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 24857614
Does it actually work to view tables, etc. within the database?

What is the path by the way?
0
 
LVL 48

Expert Comment

by:jpaulino
ID: 24857624
Try to close VS, open it again, Modify the connection to the right path and save it.
0
 

Author Comment

by:ljcor
ID: 24857662
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
 

Accepted Solution

by:
ljcor earned 0 total points
ID: 24858410
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Article by: jpaulino
XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String (http://msdn.microsoft.com/en-us/library/system.string.aspx) Literal, only instead of starting and ending with w…
Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question