Connect to the database in Classic ASP, vbscript

Connection String syntaxt for SQL Server:

Driver={SQL Native Client}; Server=SERVER_NAME;DBQ=DATABASE_NAME;UID=USERNAME; PWD=PASSWORD;

Sample:

Driver={SQL Native Client}; Server=testserver;DBQ=master;UID=aspnet; PWD=1234;
Take note that the PWD (password) is case sensitive.

Sample vbscript to connect to the database using the connectiong string above:

set cnUser = server.CreateObject("ADODB.Connection")

cnTrans.ConnectionString=GlobalConnectionString
cnTrans.Open

set rsUser = cnTrans.execute("Select username, firstname, lastname from Users")

iterate to the result set:

while not rsUser.eof

    response.write(rsUser("username")) ' get/show fieldname username

    rsUser.movenext                    ' move to the next record

wend

L.

Modify IIS Metabase

If you need to modify the IIS Metabase, you can do so by editing the Metabase.xml file directly using Microsoft Visual Studio or notepad. But before you can do so, you must enable the edit-while-running feature in IIS Manager. After your changes, don’t forget to disable the edit-while-running feature. To make sure that your changes were implemented, you might need to restart the server.

To modify the IIS Metabase, follow the following steps:

Enable the edit-while running feature of the metabase using IIS Manager:

1. In IIS Manager, right-click the local computer, and then click Properties.
2. Check the Enable Direct Metabase Edit check box
3. Click OK.

Modify the IIS metabase:

1. Open the Metabase.xml file in a text editor. The default path to this file is systemroot\system32\inetserv\metabase.xml
2. Modify the metabase properties that you wish to change in the Metabase.xml file.
3. Save the changes to the file, and close the text editor.

Disable the Edit-while running feature of the metabase using IIS Manager:

1. In IIS Manager, right-click the local computer, and then click Properties.
2. Uncheck the Enable Direct Metabase Edit check box
3. Click OK.

L.