Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
JadeV
Yak Posting Veteran
62 Posts |
Posted - 2012-09-11 : 22:16:36
|
I am going to do the assignment at school using SQL to retrieve database, but I don't have the server to retrieve database. I don't know how to make the own database to run the SQL query. I heard some people said create the web page, but I don't know how to do it.Anyone can help me how to do it?Thank you |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-09-12 : 01:55:18
|
Once the sql server is set . You'll need to create an ODBC ( although there are other ways of connecting such as DSN-less) , and connect from you your page. What scripting language are you using?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
JadeV
Yak Posting Veteran
62 Posts |
Posted - 2012-09-12 : 10:29:21
|
If create an ODBC, I must have name of data source and server, but I don't have a server |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-09-12 : 10:40:21
|
If you install SQL Express, you can use (local) as the server name (include the parentheses).Edit: You don't have to use ODBC either, or set up a DSN. You can find examples of connection strings here: http://www.connectionstrings.com/sql-server-2008 |
|
|
|
|
|