Is there a way to connect to an SQL database without using ASP/ASP.NET, PHP, etc.?
And using only Ajax, JQuery, etc.? Thanks.
8
-
In practicality it would be a huge security risk. I don't think there are any drivers for SQL server that could interpret the calls. The browser won't be able to handle the communication. Do you need this for some sort of production program, or just S&G's ?kevingreen– kevingreen2011-11-17 20:12:31 +00:00Commented Nov 17, 2011 at 20:12
-
3If by "etc.", you mean "Java" or "Ruby", then yes. Otherwise, please don't do this.Garrett Vlieger– Garrett Vlieger2011-11-17 20:19:53 +00:00Commented Nov 17, 2011 at 20:19
-
2Could you also let us know for what purpose you would like to use such an approach? I'm curious to find out because it seems like there's a huge security risk looming..Nonym– Nonym2011-11-17 20:25:06 +00:00Commented Nov 17, 2011 at 20:25
-
1Ajax doesn't "do things server side" it's just Javascript that sends requests back to the server, the server makes the DB and other calls, then returns it to the browser.kevingreen– kevingreen2011-11-17 20:32:19 +00:00Commented Nov 17, 2011 at 20:32
-
1Whatever language you're most comfortable with will work. But you will need server side code to accomplish this. PHP, Java, C#, C++, Python, Perl …kevingreen– kevingreen2011-11-17 20:47:16 +00:00Commented Nov 17, 2011 at 20:47
|
Show 3 more comments
3 Answers
I don't want to have to build or anything.
Well, you're going to, willing or not. Have a look at Creating an OData API for StackOverflow including XML and JSON in 30 minutes for how to 'build' such a feature using ASP and Endity Framework to expose an OData API.
Comments
SQL Server supported Native XML/SOAP endpoints: http://technet.microsoft.com/en-us/library/cc280436.aspx
Now deprecated in SQL Server 2008
Now of course this would mean that your SQL Server had to be able to handle HTTP requests from the client - which might be on the Internet. But it's possible, regardless of the wisdom of doing so.
Comments
It's not "SQL", but I think you use CouchDB as your database platform - that supports a REST/JSON API for querying:
