Solved

VB 2008  - What does this x mean?

Posted on 2009-07-15
8
302 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
  • 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
Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

 

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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
DataGridView Events ? 3 45
HTML - Color not displaying correctly in EMAIL. 6 38
Obtain cell value using column ID in DataGrid using VB.NET 2 19
VB.NET 2008 - SQL Timeout 9 24
If you're writing a .NET application to connect to an Access .mdb database and use pre-existing queries that require parameters, you've come to the right place! Let's say the pre-existing query(qryCust) in Access takes a Date as a parameter and l…
Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

777 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