?
Solved

sql and asp website

Posted on 2012-03-18
4
Medium Priority
?
379 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 1000 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 1000 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)

770 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