I am unable to run the Personal Organizer Login excercise with the Try It Out beginning on page 166. I get the same error using the Chapter 8 Personal Organizer Start project and adding the code required myself as I do by running the code provided in the Chapter 8 Personal Organizer completed project. The specific runtime error is 'SQLException was Unhandled' with detail "An attempt to attach an auto-named database for file H:\Wiley-2\Wrox Visual Basic Express 2005 Starter Kit\Code\Chapter 8\Personal Organizer Database File\PO-Data.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share." The program stops in the _PO_DataDataSet.Designer.vb code section highlighting the statement "Dim returnValue As Integer = Me.Adapter.Fill(dataTable)"

If anyone can assist with this problem it would be greatly appreciated. I have been unsuccessful with Chapter 7 and Chapter 8 and database connections in general!

--------------

The help section asks to...

Verify that you are connecting with valid credentials.
Make sure that the credentials you are supplying are valid. For more information, see How to: Access SQL Server Using Predetermined Credentials.

Verify that the server name is correct and that the server is running.

Make sure that you are using the correct server name, and that the server can be reached. For more information, see How to: Create Connections to SQL Server Databases.
Remarks

This exception is thrown whenever the .NET Framework Data Provider for SQL Server encounters an error generated by the server.
Messages with a severity level of 10 or less are informational and indicate problems caused by mistakes in information that a user has entered. Severity levels from 11 through 16 are generated by the user and can be corrected by the user. Severity levels from 17 through 25 indicate software or hardware errors. When a level 17, 18, or 19 error occurs, you can continue working, although you may not be able to execute a particular statement.

The SqlConnection remains open when the severity level is 19 or less. When the severity level is 20 or greater, the server usually closes the SqlConnection. However, the user can reopen the connection and continue. In both cases, a SqlException is generated by the method executing the command.
For information on the warning and informational messages sent by SQL Server, see the Troubleshooting section of SQL Server Books Online.

hi,
I have the same problem...
have you found a solution?If so could you also pls explain it to me...

thanx!

Can

The easiest way to fix this is:

In Solution Explorer right click My Project then select open
on the left side of form select settings
click on the value column and select the database file for the
chapter your working on.