sql server

poissys

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

you want sql server 2005 express, which is free:

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

Rgds,

Dave

Tar.Aldarion

Looks free, it's express.

poissys

thanks a million guys
lets hope it works!

poissys

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

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

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

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

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

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

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

You go for MySQL, it free.

stevenmu

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

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

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

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

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

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

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

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

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

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

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

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

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

ChRoMe

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

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.