A step by step tutorial teaching you how to create your own chat client and chat server easily in C#, for local networks or the Internet.
A C# tutorial showing you how to make use of WMI to extract information on disk drives, such as model, capacity, sectors and serial number.
This tutorial will teach you how to calculate the shipping cost based on the weight, height, length and depth of the box, the distance and the UPS service type.
Creating a Rich Text Editor using JavaScript is easier to do than you might think, thanks to the support of modern browsers; this tutorial will walk you through it.
Setting up MS SQL Server 2000This guide will show you how to install the Microsoft SQL Server Desktop Engine 2000A for your localhost server. |
On Sunday, June 6th 2004 at 11:02 AM By Andrew Pociu (View Profile) ![]() ![]() ![]() ![]() (Rated 4.2 with 30 votes) |
||
MSDE is the free version database for developing purposes. Perfect for learning at localhost . This guide shows you how to set it up on Windows XP (it works on other similar operating Systems - Windows 2000, Windows 2003, etc.).Download Microsoft SQL Server Desktop Engine 2000A from Microsoft Website: Download from Microsoft Extract the package. Use the default path (C:\MSDERelA). Open Command Prompt and if you are already in drive C: (if not type 'C:') enter the setup directory using 'Change Dir': CD C:\MSDERelA You must execute setup.exe with a parameter that specifies a password, therefore using the following in the command prompt: setup.exe SAPWD="yourPassword" replace yourPassword with your own password, of course .There are other parameters with which you can install SQL Server Desktop Engine. Consult the file named ReadmeMSDE2000A.htm for details. After the demanded restart, look into the taskbar, it should be a icon that looks like a server, and the classic play (>) that means the server is running. Installing Microsoft SQL Web Data AdministratorIt's a great free utility provided by Microsoft for administrating your database. You can download it from here. It has only a bit over 3 MB so it won't take much to download. There's no trick with installing this one, after running the downloaded file (setup.msi). Start the newly installed application from the Start menu. Press start in the window that shows up (leave the setting unchanged, by default IIS option is selected). A browser window will open 'http://localhost/webadmin/default.aspx', the place from where you'll manage you databases. Normally you just press the Login button and leave the fields with their default value, this should take you to the available databases. Also some related tutorial that you might be interested in is Setting up your ASP .NET server (IIS). |
|||
Digg It!
Del.icio.us
Reddit
StumbleIt
Newsvine
Furl
BlinkList
|
|||
|
|||
Current CommentsThanks!
This is a short but realy great and helpful tutorial!
i neet that tutorial
I spend a lot of time trying to log in using Microsoft SQL Web Data Administrator in vain. But I found a post at SQL Junkies that probably could save others the headacre http://www.sqljunkies.com/Forums/ShowPost.aspx?PostID=2084
it really comprehensive and helpful.
where is the tutorial
this tutorial was simple and really helped me out!
You folks have made the complicated simple... wish everyone thought the way you do!
i've already tried this, but my computer did not restart and there's no server icon in my taskbar. Is it because i have mySQL in my computer??
rink, first of all you must have SQL-Server desktop edition installed...
wow Thank you I have been trying to get any MS SQL installed But this put it to Basics of MS
Brilliant! Simple enough to follow easily and works like a treat! Has saved me hours!
I'm having trouble connecting to my MSSQLServer. I want to connect to it from my PC. I can see the Server, but when I try to connect to the SQL Server to see the databases I get an error saying that the server is not found or access is denied. Any thoughts on what I might be doing wrong? I'm using MS Visual Studio.Net to connect from my pc to my server that is on my network.
how to import and export data using DTS?
pl tell me where can i get the tutorial
HI
Thanks for alll
Extract the package. Use the default path (C:\\MSDERelA).
Open Command Prompt and if you are already in drive C: (if not type \'C:\') enter the setup directory using \'Change Dir\':
CD C:\\MSDERelA
You must execute setup.exe with a parameter that specifies a password, therefore using the following in the command prompt:
setup.exe SAPWD=\"yourPassword\"
replace yourPassword with your own password, of course .
There are other parameters with which you can install SQL Server Desktop Engine. Consult the file named ReadmeMSDE2000A.htm for details.
After the demanded restart, look into the taskbar, it should be a icon that looks like a server, and the classic play (>) that means the server is running.
I HAVE GOT INSTALLED BUT UNABLE TO OPEN THE ENTERPRISE MANAGER
ERROR REPORTS Snap-in failes to initialize
please hep me
Even in 2008 this was helpfull for me, thanks.
MSDERelA
You are a lifesaver! I would have been lost without this tutorial and the one for setting up ASP .NET 1.1. Thank you.
404 at the link to download web data administrator :(
Thanks very helpfull
Check this article ( http://www.shahriarnk.com/Shahriar-N-K-Research-Embedding-SQL-in-C-Sharp-Java.html ) for details on how to connect to SQL Server database from C#.NET database applications as well as Java database applications. It also describes how to pass embedded SQL queries (SELECT, INSERT, UPDATE, DELETE), calling stored procedures, pass parameters etc.
Shahriar Nour Khondokar: http://www.shahriarnk.com/
Check this article ( http://www.shahriarnk.com/Shahriar-N-K-Research-Embedding-SQL-in-C-Sharp-Java.html ) for details on how to connect to SQL Server database from C#.NET database applications as well as Java database applications. It also describes how to pass embedded SQL queries (SELECT, INSERT, UPDATE, DELETE), calling stored procedures, pass parameters etc.
Shahriar Nour Khondokar: http://www.shahriarnk.com/
vcry good tutorial
Nonsense is everything, so we pauperism to sure that there are values on what we are sex to fact our subscribers participating. Trait them vexed is one perception we moldiness connectedness do!
I rale enjoyed this ringing leger. Savor existing them event. Greets !This is a in fact certain see for me, Unoriginality mate that you are earthborn presuppose of the incomparable bloggers I e'er saw. Thanks for similarity this consultive article.
I accept your website perfect for my needs. It contains wonderful and assistive posts. I circumvolve strongbox most of them and got a lot from them. To me, you are doing the towering upshot. Disseminate on this. employ at come In the end, I would corresponding to add you for making donated a presentable website
I found this useful and attractive blog i think its very obliging and information able.I would like to thank you for the pains you have made in writing this editorial.
It was very well authored and easy to understand. Unlike additional blogs I have read which are really not that good.Rec to rec companies Hong Kong
great post
Such a wonderful thing for you to do, for providing that link to microsoft. Now I can setting up MS SQL Server without problems!
This version of MSQL server is a bit outdated but I can't see any difference between new one. Hopefully this technology evolve into something more advanced
thank u for providing me information on List View.
I want to know how i can display data in datalist in Newsletter layout and Thank you so much, this is easy to understand and fun to continue along with. I am a migrating VB.NET/C# Developer looking for an insight into VC .NET. I've found the VC tutorials on many sites to be confusing, and the navigation around the sites to be near impossible to use! Thanks once again.
You need to start another tutorial, for newer versions of MS SQL Server.
Once you have recreated the problem and captured these steps, you can save them to a file and send it to your support person, who can then open it up and view
I spend a lot of time trying to log in using Microsoft SQL Web Data Administrator in vain. But I found a post at SQL Junkies that probably could save others the headacre http://www.sqljunkies.com/Forums/ShowPost.aspx?PostID=2084
This is old version of MS SQL server but all the installing process still remain the same
I am very thankful to the people who post this blog and also I have noticed that there are more people who are good in posting here.
Ontario Solar Power
Once you have recreated the problem and captured these steps, you can save them to a file and send it to your support person, who can then open it up and view
what a good post, I am visiting this site first time
what a good post, I am visiting this site first time
I've heard reports of early adopter focused sites whose social referral traffic has started to matter. But it certainly doesn't seem to be a mainstream phenomenon.
"you can stop eating if you don't give in to it." Please note she only said this after I told her I was losing weight.
You need to start another tutorial, for newer versions of MS SQL Server.
I've been absent for some time, but now I remember why I used to love this web site. Thank you, I will try and check back more frequently. How frequently you update your web site?
I've been absent for some time, but now I remember why I used to love this web site. Thank you, I will try and check back more frequently. How frequently you update your web site?
I've been absent for some time, but now I remember why I used to love this web site. Thank you, I will try and check back more frequently. How frequently you update your web site?
I really liked your article and I shared with my friends in my facebook account . Pergolas Sydney
Incredible contribution,It is my opinion you could have unquestionably put together a site I wish to check back on on the regular basis. Keep it up.
I've heard reports of early adopter focused sites whose social referral traffic has started to matter. But it certainly doesn't seem to be a mainstream phenomenon.
But it certainly doesn't seem to be a mainstream phenomenon.
I tried most of the MSQL version, and I must say... they are pretty difficult to use. The help section is not that helpful either. Quite poor, I might say...
MSQL is not acually that difficult. Once you learn the basics, it's quite smooth running. You just need to always keep up to date with the updates. :)
MySQL has a very ambitious schedule for getting its high price-performance databases up to enterprise standards. Note I did say databases. But MySQL's price-performance advantage may well hit a wall at the topend as more advanced computing through Web Services, distributed systems, and asynchronous processing in SOA and BPM workflows just demands a much higher standard of database engine.
Great blog article about the Great blog article about this topic, I have been lately in your blog once or twice now. I just wanted to say hi and show my thanks for the information provided.
This site has a lot good information on it, I check on it whenever I’m online. I wish other sites spent as much time as this one does making information clearer to readers like myself.78617 homes
This site has a lot good information on it, I check on it whenever I’m online. I wish other sites spent as much time as this one does making information clearer to readers like myself.78617 homes
I've found the VC tutorials on many sites to be confusing, and the navigation around the sites to be near impossible to use! Thanks once again.
This is a in fact certain see for me, Unoriginality mate that you are earthborn presuppose of the incomparable bloggers I e'er saw. Thanks for similarity this consultive article.
.NET database applications as well as Java database applications. It also describes how to pass embedded SQL queries (SELECT, INSERT, UPDATE, DELETE), calling stored procedures, pass parameters etc.
78617 homes
Good!This post is creative,you'll find a lot of new idea,it gives me inspiration.I believe I will also inspired by you and feel about extra new ideas.thanks
he following time I read a weblog, I hope that it doesnt disappoint me as a lot as this one. I mean, I know it was my choice to read, however I actually thought youd have one thing interesting to say
the loss of retirement life as a possible choice for most, in addition to developing aggravation for many who function throughout substantial companies, this is a developing development.
The defeat of retreat life as a possible plectrum for most, in addition to aging frustration for dozens who role throughout substantial companies, this is a maturing development.
http://www.louisvuittonpursebags.org/ Louis Vuitton Purses
http://www.louisvuittonsonlineshop.org/ Louis Vuitton Outlet
http://www.greatlouisvuittonsbags.com/ louis vuitton outlet
http://www.cheap-suprashoe.net/ supra shoes
http://www.officiallouisvuittonzones.net/ louis vuitton outlet
http://www.hermesoutletsus.net/ hermes bags
Begin just about any design diary presently together with you might be sure to identify
Begin just about any design diary presently together with you might be sure to identify
Begin just about any design diary presently together with you might be sure to identify
Begin just about any design diary presently together with you might be sure to identify
Begin just about any design diary presently together with you might be sure to identify
Begin just about any design diary presently together with you might be sure to identify
Begin just about any design diary presently together with you might be sure to identify
This is great post. I actually searched for this type of post. Thus i am here. I read the post and amused to see its content. This is really a helpful post. Thanks for sharing this kind of informative post. pokies android
I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well. In fact your creative writing abilities has inspired me to start my own Blog Engine blog now. Really the blogging is spreading its wings rapidly. Your write up is a fine example of it….. Seo
I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well. In fact your creative writing abilities has inspired me to start my own Blog Engine blog now. Really the blogging is spreading its wings rapidly. Your write up is a fine example of it….. Seo
I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well. In fact your creative writing abilities has inspired me to start my own Blog Engine blog now. Really the blogging is spreading its wings rapidly. Your write up is a fine example of it….. Seo
I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well. In fact your creative writing abilities has inspired me to start my own Blog Engine blog now. Really the blogging is spreading its wings rapidly. Your write up is a fine example of it….. Seo
I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well. In fact your creative writing abilities has inspired me to start my own Blog Engine blog now. Really the blogging is spreading its wings rapidly. Your write up is a fine example of it….. Seo
I read the post and amused to see its content. This is really a helpful post. Thanks for sharing this kind of informative post.e urdu point
I read the post and amused to see its content. This is really a helpful post. Thanks for sharing this kind of informative post.e urdu point
I read the post and amused to see its content. This is really a helpful post. Thanks for sharing this kind of informative post.e urdu point
I read the post and amused to see its content. This is really a helpful post. Thanks for sharing this kind of informative post.e urdu point
I read the post and amused to see its content. This is really a helpful post. Thanks for sharing this kind of informative post.e urdu point
I read the post and amused to see its content. This is really a helpful post. Thanks for sharing this kind of informative post.e urdu point
I read the post and amused to see its content. This is really a helpful post. Thanks for sharing this kind of informative post.e urdu point
You must execute setup.exe with a parameter that specifies a password, therefore using the following in the command prompt:
I'm glad that I had the fortune to stumble across your blog. It’s definitely an important issue that not enough people are talking about and I'm glad that I got the chance to see all the angles.
I read the post and amused to see its content. This is really a helpful post. Thanks for sharing this kind of informative post http://www.nulleurocent.de
I read the post and amused to see its content. This is really a helpful post. Thanks for sharing this kind of informative post http://www.nulleurocent.de
This is really a helpful post. Thanks for sharing this kind of informative post http://www.nulleurocent.de
This is really a helpful post. Thanks for sharing this kind
Loads of excellent writing here. It was indeed very helpful and insightful while being straight forward and to the point. Thanks for the posting.
I want to know more about how to use it for a website.
I want to know more about how to use it for a website.
free version database for developing purposes. Perfect for learning at localhost . This guide shows you how to set it up on Windows
Nice to be here and see your post! So appreciate! charming date
Related Tutorials
Related Source Code
SQL Job SearchFrom the creators of Geekpedia, a revolutionary new coupon website!
BargainEZ has coupons codes, printable coupons, bargains and it is the leading source of Passbook coupons for iPhone and iPod touch devices.