|
|
 |
BOOK: Wrox's SQL Server 2005 Express Edition Starter Kit ISBN: 978-0-7645-8923-2  | This is the forum to discuss the Wrox book Wrox's SQL Server 2005 Express Edition Starter Kit by Rajesh George, Lance Delano; ISBN: 9780764589232 |
|
Welcome to the p2p.wrox.com Forums.
You are currently viewing the BOOK: Wrox's SQL Server 2005 Express Edition Starter Kit ISBN: 978-0-7645-8923-2 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other programmers’ questions, win occasional prizes given to our best members, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
|
 |
|
|
 |
October 10th, 2006, 04:02 PM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Location: Naperville, IL, USA.
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Create Database Error
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
__________________
Rand
|
October 12th, 2006, 01:41 PM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Location: Naperville, IL, USA.
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
October 17th, 2006, 01:12 PM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Location: Naperville, IL, USA.
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
January 26th, 2008, 06:15 PM
|
|
Registered User
|
|
Join Date: Jan 2008
Location: Wasington, DC, USA.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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!
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
