anyone know how to use VBScript to call the data from the MS SQL SERVER database?

And how to assign the database record value to Document.write, plus the text together.

Example:

Dim a
a = DoctorsProfile.DoctirName.value

Is it correct?

--------------------------------------------

Next one would be:

Document.write DoctorsProfile.DoctorName + "is specialize in eye diseases"

Is it correct?

--------------------------------------------

How to write them, can anyone please help me?
In the ASP page I also created three recordset, meaning that there are three different tables.

I'm very appreciate your help. And would be very thankful to you.
Please reply soon, as soon as possible.

Best regards,
Yutaka