Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 394
  • Last Modified:

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.
0
GegH
Asked:
GegH
  • 2
2 Solutions
 
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
 
WebF00LCommented:
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
 
BuggyCoderCommented:
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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now