sql and asp website

Can someone tell me how to get started, i think i'm missing something.
I have set up websites with MS Access before but i am struggling to even get started with sql.

How do i create an sql database and set it up on my website? i have no idea where to start.
GegHAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
WebF00LConnect With a Mentor Commented:
Hi

Depending on what SQL server you have (express or standard) i would install or use Microsoft SQL server management Studio.

There you can execute sql commands to create your database and tabels.

http://www.ozekisms.com/index.php?owpn=264


//WebFooL Untangle Evangelist
0
 
GegHAuthor Commented:
Should have said, i am trying to use MS Sql, and dreamweaver and develop it on a windows 7 pro 64bit machine.
0
 
BuggyCoderConnect With a Mentor Commented:
0
 
GegHAuthor Commented:
I think i may have been over thinking this.

I have been trying to create a new server installation (in express) in order to build a database. This never really made sense to me as that would require a connection to my machine to read the database?

I then noticed in Sever Management studio the compact edition to create a new sdf file. Is this what i am meant to be using?
I guess i create this sdf file in my inetpub/website folder so i can upload it to the website?
Is it best to save the sdf file in the root website directory or a sub-directory?

As you can tell, i'm starting at the bottom here, so many questions.

If i should be using something other than compact edition i'm stuffed because SQL server management studio can't find any database engines.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.