Print Page | Close Window

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.
You'll want to uninstall your current MSDE install and reboot before installing it though.



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

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.
http://www.aspenterprisemanager.com/ - http://www.aspenterprisemanager.com/

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
I've used DbaMgr2k  in the past, but I understand MSDE.biz is pretty good too.



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

Lead me not into temptation... I know the short cut, follow me.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net