sql server

poissys · 17-01-2008 12:43pm #1

iv tried finding sql server 2005, but it loks like its not free

is this true or not or am i going to the wrong sites, not sggesting i download an illegal copy of anything.
but its just i downloaded here:

http://www.microsoft.com/downloads/details.aspx?FamilyID=220549b5-0b07-4448-8848-dcc397514b41&displaylang=en

but the installation process only seems to go so far.
any ideas why this might be
im running xp!

DJB · 17-01-2008 12:47pm

you want sql server 2005 express, which is free:

http://www.microsoft.com/sql/editions/express/default.mspx

Rgds,

Dave

Tar.Aldarion · 17-01-2008 12:47pm

Looks free, it's express.

poissys · 17-01-2008 12:56pm

thanks a million guys
lets hope it works!

poissys · 17-01-2008 1:32pm

i installed it successfully, but I cant seem to find it in the list of programmes that I have installed
where would it be?
im using visual studio if thats any help.

fasty · 17-01-2008 2:10pm

Download Microsoft SQL Server Management Studio Express from Microsoft. It's another freebie that will let you access your newly installed SQL Server. The alternative is a built in command line tool.

poissys · 17-01-2008 2:19pm

fasty wrote: »

Download Microsoft SQL Server Management Studio Express from Microsoft. It's another freebie that will let you access your newly installed SQL Server. The alternative is a built in command line tool.

got it downloaded it and shes working lovely, just need to read up on how to create a db now and how to connect to asp.net!
thanks

ChRoMe · 17-01-2008 4:46pm

if your going to be using express because its free can i suggest mysql? Just for the simple fact that express is a VERY stripped down database and can cause a beginner headaches that are not your fault.

poissys · 17-01-2008 5:08pm

thats a very good point, since u sad that iv gone away and downloaded it and its all installing work working the way it should, plus i checked out books onlin e and it seems to be a far more straight forward connection process.
thanks for your help dude, means a lot!

ChRoMe wrote: »

if your going to be using express because its free can i suggest mysql? Just for the simple fact that express is a VERY stripped down database and can cause a beginner headaches that are not your fault.

fasty · 17-01-2008 8:34pm

ChRoMe wrote: »

if your going to be using express because its free can i suggest mysql? Just for the simple fact that express is a VERY stripped down database and can cause a beginner headaches that are not your fault.

That's not true. SQL Express' biggest limitation are that database size is limited to 4GB and they can't use dual processors. Most of the stuff missing are advances features that the OP won't need to worry about.

For a developer using Visual Studio in a window environment MS SQL is a winner.

Check out this comparison if you don't believe me!

DJB · 17-01-2008 8:38pm

I think the limits are 4GB database size, 1 processor, and 1GB or RAM. There's no DTS and a few other advanced indexing features.

As fasty said, OP will be fine with Express!

mach1982 · 17-01-2008 11:21pm

You go for MySQL, it free.

stevenmu · 18-01-2008 12:04am

As is SQL Server Express. And with the management studio express and it's integration with Visual Studio and the .net languages it's far simpler for a beginner to get setup and get to grips with.

poissys · 18-01-2008 12:58pm

do u need to install IIS to get sql to work?
will iis work with xp home edition, i have heard a few people say it doesnt, but anywhere the iis is available for download it doesnt specify whther the download is for home edition or pro, it just says XP.

DJB · 18-01-2008 1:07pm

You don't need IIS to run SQL express but if you want to run asp or asp.net pages on your computer you need IIS installed. Not sure if SQL Express runs on XP Home. Never tried. I know IIS will only run on XP Pro as I had to upgrade a laptop a few years back.

poissys · 18-01-2008 1:11pm

DJB wrote: »

You don't need IIS to run SQL express but if you want to run asp or asp.net pages on your computer you need IIS installed. Not sure if SQL Express runs on XP Home. Never tried. I know IIS will only run on XP Pro as I had to upgrade a laptop a few years back.

whats involved in getting an upgrade?

MySelf56 · 18-01-2008 1:29pm

If you want to start/learn asp.net skills with SQL server Express, you can download and use Microsoft Visual Web Developer Express 2005, it has seem less integration with SQL server.

http://www.microsoft.com/express/2005/download/default.aspx

dont forget use http://www.asp.net web site as one-stop resource for ASP .net.

stevenmu · 18-01-2008 1:38pm

Using Visual Studio you don't need IIS, VS has it's own built in web server.

And if you want to run ASP.Net pages outside of VS you can download Cassini (works on Home aswell)

(edit: I believe the web server in VS is a form of Cassini but not sure)

ChRoMe · 18-01-2008 4:48pm

fasty wrote: »

That's not true. SQL Express' biggest limitation are that database size is limited to 4GB and they can't use dual processors. Most of the stuff missing are advances features that the OP won't need to worry about.

For a developer using Visual Studio in a window environment MS SQL is a winner.

Check out this comparison if you don't believe me!

huh? thats a comparison against the other MS SQL server products. I'd like to see a comparison chart of express against mysql

DJB · 18-01-2008 5:20pm

poissys wrote: »

whats involved in getting an upgrade?

You need to get pro version (oem) if possible. Don't know if it's still available as Vista is taking over these days. It used to cost about 100-150 for the upgrade.

What are you trying to do anyway? Develop websites, etc?

fasty · 18-01-2008 8:26pm

ChRoMe wrote: »

huh? thats a comparison against the other MS SQL server products. I'd like to see a comparison chart of express against mysql

Do you actually think MS SQL 2005 is lacking in features compared to MySQL?

poissys · 19-01-2008 1:47pm

does visual studio automatically install teh .net framework?
iv decided to use mysql database, and i need to install the odbc connector, but even though i have visual studio install, its stil asking for the .net framework, saying it aint installed.
wat could this be?

fasty · 19-01-2008 2:13pm

Yeah, it installs the .Net framework... 3.5 for VS2008, 2.0 for VS2005.

When does it tell you .Net isn't installed? To use MySQL with an ODBC connection, do you need to install an ODBC driver? Did that install okay? I've never used MySQL in a Windows environment, I'm used to just using C libraries instead so more info on what goes wrong is needed for me to help.

Also, I still suggest sticking with MS SQL 2005, there are no advantages, in your current situation, in using MySQL instead (and if you're going to be an ASP.Net dev in the future, no point at all imo)

poissys · 19-01-2008 5:43pm

got it, i found this: http://dev.mysql.com/downloads/connector/net/5.1.html

and downloaded it here and it worked perfectly.

i then used the following code, as featured in this tutorial, and im getting up errors saying that:

MySqlConnection and MySqlDataAdapter are not defined.

i have NO idea why these errors could be coming up.

by the way for anyone doing similiar work this tutorial is fantastic:

http://www.15seconds.com/issue/050210.htm

fasty · 19-01-2008 6:00pm

Did you add the required .Net/MySQL DLLs to your project? Googling tell me it's MySql.Data.DLL

ChRoMe · 20-01-2008 6:07pm

fasty wrote: »

Do you actually think MS SQL 2005 is lacking in features compared to MySQL?

No but I think Express is. Are you actually reading this thread??

You sound like you need a visit from captain reading comprehension.

mewso · 21-01-2008 4:47pm

ChRoMe wrote: »

No but I think Express is. Are you actually reading this thread??

You sound like you need a visit from captain reading comprehension.

I think you might need to read the thread. The limitations of Sql 2005 were discussed and considered not of major consequence to the OP or any average web developer learning to develop a website for that matter.

sql server

Comments