Create Database Error

rgerald · October 10th, 2006, 03:02 PM

When I use VB2005EE to add a database to my project. See Ch.3 - Page 46. I get the following error.

Quote:

quote:
Microsoft Visual Basic 2005 Express Edition

             The file "H:\MyDocuments\Visual Studio 2005\Projects\MyFirstApp\MyFirstApp\Database2.mdf" is on a network path that is not supported for database files.

             CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

             User does not have permission to alter database 'D2F7C226-9B40-4F31-8093-52B099626AD1' or the database does not exist.
             ALTER DATABASE statement failed.

             User does not have permission to alter database 'D2F7C226-9B40-4F31-8093-52B099626AD1' or the database does not exist.
             ALTER DATABASE statement failed.

             The database 'D2F7C226-9B40-4F31-8093-52B099626AD1' does not exist. Use sp_helpdb to show available databases.

What is the cause and the remedy for this problem?

Rand

rgerald · October 12th, 2006, 12:41 PM

The problem seemed to go away when I moved the database and project directory trees to a local workstation as opposed to a directory tree on the network.

Rand

rgerald · October 17th, 2006, 12:12 PM

The VB2005EE (both the one on the CD and the newer (SP1) version at the Microsoft download site seem to have problems with default directories.

If your windows default directory is on a network drive you get the error shown above. If you try moving the application to a local directory (folder), you get other problems - the database won't connect.

Perhaps it is only designed to work when the default MyDocuments folder is on the C: drive. If this is the case, it should be clearly documented - which it is not.

Rand

Sirocco · January 26th, 2008, 06:15 PM

I experienced the same problem. I installed the CD at work and at home. It seems there are fewer problems generally on my home PC, which doesn't bode well because SQL Server is intended to be run over networks!