Solved

sql and asp website

Posted on 2012-03-18
4
337 Views
Last Modified: 2012-03-22
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
Comment
Question by:GegH
  • 2
4 Comments
 

Author Comment

by:GegH
ID: 37734479
Should have said, i am trying to use MS Sql, and dreamweaver and develop it on a windows 7 pro 64bit machine.
0
 
LVL 3

Accepted Solution

by:
WebF00L earned 250 total points
ID: 37734504
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
 
LVL 20

Assisted Solution

by:BuggyCoder
BuggyCoder earned 250 total points
ID: 37734565
0
 

Author Comment

by:GegH
ID: 37741413
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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now