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.