XML remote SQL command execution


This demo demonstrates how to use a browser only, thin client application to run SQL statements on a server over the Web. This sample displays XML to let you see how messages are passed between client and server. Use the top textbox to type in the SQL XML document to run. To see an example that uses the returned values from the XML see the httpsql2.asp demo.

Try putting in invalid SQL and property names to see error handling. 

Note: This demo is limited to SELECT, INSERT and EXECUTE statements for security reasons. You can use the TT_CUST and wwItems tables to access data. For accessing a SQL Server database add: <csqlconnectstring>dsn=pubs;uid=sa</csqlconnectstring> and use SELECT * FROM Authors. 

Input XML:

Result XML: