asked on 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.
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.
Microsoft SQL Server.NET ProgrammingWeb Languages and Standards
Last Comment
GegH
ASKER
Should have said, i am trying to use MS Sql, and dreamweaver and develop it on a windows 7 pro 64bit machine.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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.
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.