| Author |
 Topic Search  Topic Options
|
davidshq 
Senior Member
Joined: 29 July 2003
Location: United States
Status: Offline
Points: 299
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Sample Microsoft Databases.
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
|
|
|
 |
dpyers
Senior Member
Joined: 12 May 2003
Status: Offline
Points: 3937
|
Post Options
Thanks(0)
Quote Reply
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& 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.
|
|
davidshq
Senior Member
Joined: 29 July 2003
Location: United States
Status: Offline
Points: 299
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
dpyers
Senior Member
Joined: 12 May 2003
Status: Offline
Points: 3937
|
Post Options
Thanks(0)
Quote Reply
Posted: 23 July 2004 at 11:30am |
You may want to check out the news group news:microsoft.public.sqlserver.setup for info on getting msde straightened out.
|
Lead me not into temptation... I know the short cut, follow me.
|
|
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
dpyers
Senior Member
Joined: 12 May 2003
Status: Offline
Points: 3937
|
Post Options
Thanks(0)
Quote Reply
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/
Other management interfaces for msde (some free) are here - 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.
|
|
