here how I've done it in the past using
<%
sql1 = "SELECT My_folders.folder, My_folders.username, My_folders.password, My_request.client FROM My_request INNER JOIN My_folders ON My_request.ids = My_folders.ids where My_folders.ids = " & request("ids"

Dim oRSNew
Set oRSNew = Server.CreateObject("ADODB.Recordset"

oRSNew.open sql1, "dsn=MyDSN;uid=MyID;pwd=MyPSSWD"
response.buffer = True
response.expires = 0
'create and populate the PDF File =======================================================================
Set APToolkit = Server.CreateObject("APToolkit.Object"

APToolkit.OutputPageWidth=612
APToolkit.OutputPageHeight=792
Y = APToolkit.OpenOutputFile("MEMORY"
'Set field values to equal your variables
vara = "Company FTP Site instructions for " & ORSNew("Client"

varb1 = "Open your FTP Software & follow directions of your software to connect to ftp://xx.xxx.xx.xxx. "
varb2 = "You may need to enter JUST the IP address depending your FTP Software. "
varb3 = "Your Account Representative will call you with the username and password."
varb4 = "Leave initial remote directory as default or leave blank."
varb5 = "Upload, Download, or delete as necessary."
varb6 = "After the file completes transfer, please email your account representative"
varb7 = "to confirm integrity of the file transfer (typically the byte count of the file)."
varc = "If using browser (such as Internet Explorer)"
varc1 = "Type the following URL in the address bar: FTP://username@xx.xxx.xx.xxx "
varc2 = " Press the Enter key."
varc3 = " Enter the username & password as prompted."
varc4 = " Drag files into the open browser window."
varc5 = " After the file completes transfer, please email your account representative"
varc6 = "to confirm integrity of the file transfer (typically the byte count of the file)."
vard = "If you need assistance, please e-mail ME@company.com or call (xxx) xxx-xxxx."
APToolkit.SetFont "Times-Roman",18
APToolkit.LineWidth(1)
'=========================================Header Section======================
'APToolkit.PrintText 36,548,reqTitleLine
APToolkit.PrintText 36,720,vara
APToolkit.SetFont "Times-Roman",12
APToolkit.PrintText 36,660,varb1
APToolkit.PrintText 36,640,varb2
APToolkit.PrintText 36,620,varb3
APToolkit.PrintText 36,600,varb4
APToolkit.PrintText 36,580,varb5
APToolkit.PrintText 36,560,varb6
APToolkit.PrintText 36,540,varb6
APToolkit.SetFont "Times-Roman",18
APToolkit.PrintText 36,500,varc
APToolkit.SetFont "Times-Roman",12
APToolkit.PrintText 36,480,varc1
APToolkit.PrintText 36,460,varc2
APToolkit.PrintText 36,440,varc3
APToolkit.PrintText 36,420,varc4
APToolkit.PrintText 36,400,varc5
APToolkit.PrintText 36,380,varc6
APToolkit.PrintText 36,320,vard
'=======================================Print Out Section ====================
Y = APToolkit.CloseOutputFile()
zz = APToolkit.BinaryImage
response.expires = 0
response.clear
response.ContentType="application/pdf"
response.AddHeader"Content-Type","application/pdf"
response.AddHeader"Content-Disposition","inline;filename=ftppages.pdf"
response.BinaryWrite zz
response.End
set APToolkit = nothing
%>