Sample Microsoft Databases.
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=11269
Printed Date: 30 March 2026 at 4:19am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Sample Microsoft Databases.
Posted By: davidshq
Subject: Sample Microsoft Databases.
Date Posted: 23 July 2004 at 9:33am
|
I've been working through this book Beginning ASP.NET in VB.NET and have generally been writing a new database when the guy has been using the pubs database from Microsoft, b/c I don't have SQL Server, so I didn't have it. Anyways, its gotten to the point where that is getting more and more difficult to do so I downloaded the Sample Scripts which generate the databases but at first I was getting some error when I was running OSQL. So I uninstalled and reinstalled MSDE. But now it doesn't even think there is an osql program. Any suggestions? I just want to use the pubs database. :-P ------------- - http://www.davemackey.net/" rel="nofollow - Dave Mackey - Virtual Home. |
Replies:
Posted By: dpyers
Date Posted: 23 July 2004 at 10:47am
|
You're doing it the hard way. Pick up SQL Server 2000 Developer Edition - http://www.microsoft.com/products/info/product.aspx?view=22&pcid=9f57fd61-e1cb-46eb-881c-5289ffcc1456&type=ovr - http://www.microsoft.com/products/info/product.aspx?view=22& amp;pcid=9f57fd61-e1cb-46eb-881c-5289ffcc1456&type=ovr Goes for $50 US at MS. $10-$15 cheaper at 3rd party sellers. Includes Enterprise Manager, which is cheap at twice the price. Great for managing local and web db's, exporting local stuff to your web host, etc. ------------- 
Lead me not into temptation... I know the short cut, follow me. |
Posted By: davidshq
Date Posted: 23 July 2004 at 11:04am
|
:-( I wish I had $50 for it. I'm afraid I'm running on thin rubber right now. ------------- - http://www.davemackey.net/" rel="nofollow - Dave Mackey - Virtual Home. |
Posted By: dpyers
Date Posted: 23 July 2004 at 11:30am
|
You may want to check out the news group news:microsoft.public.sqlserver.setup - news:microsoft.public.sqlserver.setup for info on getting msde straightened out. -------------
Lead me not into temptation... I know the short cut, follow me. |
Posted By: michael
Date Posted: 23 July 2004 at 1:40pm
|
Make sure that you have the path to your sql server binn in your path, otherwise go into that dir to execute osql from there. msde itself is fine for local, just download the web data administrator from asp.net it does most things you need without having to have entman ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: dpyers
Date Posted: 23 July 2004 at 1:58pm
|
If tou have access to .net, this is a pretty good web-based tool for mssql. Has to run under .net though. Other management interfaces for msde (some free) are here - http://www.microsoft.com/sql/msde/partners/default.asp - http://www.microsoft.com/sql/msde/partners/default.asp -------------
Lead me not into temptation... I know the short cut, follow me. |