p2p.wrox.com Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old October 10th, 2006, 04:02 PM
Friend of Wrox
Points: 719, Level: 10
Points: 719, Level: 10 Points: 719, Level: 10 Points: 719, Level: 10
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Naperville, IL, USA.
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit!
Reply With Quote
  #2 (permalink)  
Old October 12th, 2006, 01:41 PM
Friend of Wrox
Points: 719, Level: 10
Points: 719, Level: 10 Points: 719, Level: 10 Points: 719, Level: 10
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Naperville, IL, USA.
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit!
Reply With Quote
  #3 (permalink)  
Old October 17th, 2006, 01:12 PM
Friend of Wrox
Points: 719, Level: 10
Points: 719, Level: 10 Points: 719, Level: 10 Points: 719, Level: 10
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Naperville, IL, USA.
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit!
Reply With Quote
  #4 (permalink)  
Old 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
Default

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!

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit!
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Create Database Error when Attempting SQL Security wirerider ASP.NET 2.0 Professional 1 March 6th, 2007 07:19 PM
How to create a Database koushikroy2001 SQL Language 2 January 4th, 2006 04:03 AM
Create database Yee MySQL 2 November 5th, 2004 06:14 AM
Programmically create a database? JeffMM Classic ASP Databases 7 March 20th, 2004 05:32 PM
How to create a new database? gpc Classic ASP Databases 17 December 19th, 2003 10:24 AM



All times are GMT -4. The time now is 08:08 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
© 2010 Wiley Publishing, Inc