Search for the words "Tutorial: Send a Query to the Database." Copy the following script and paste it under the comment.
<Script Language= "VBScript">
SUB Window_OnLoad
Server.Value = "http://<%=Request.ServerVariables("SERVER_NAME")%>"
Connect.Value = "DSN=AdvWorks"
SQL.Value = "Select * from Products"
END SUB
SUB Run_OnClick
ADC.Server = Server.Value
ADC.Connect = Connect.Value
ADC.SQL = SQL.Value
ADC.Refresh
END SUB
Note When you specify the data source through the Connect property, you will usually provide a data source name, user ID, and password (for example, "DSN=SalesDB;UID=Manager;PWD=secret;"). With Microsoft Access databases, you don't need to specify a user ID (UID) or password (PWD).
© 1997 Microsoft Corporation. All rights reserved. Terms of Use.