asp & sql database

I am having issues. Maybe my code is wrong somewhere.. HELP..

<%id = Request("ad")

Set objConn = Server.CreateObject ("ADODB.Connection")
Set objRec = Server.CreateObject ("ADODB.Recordset")
Set MyConn=server.createobject("ADODB.Connection")

set filesys=CreateObject("Scripting.FileSystemObject")

' get the property id from file name

set filesys=CreateObject("Scripting.FileSystemObject")
Set MyFileObject=server.createobject("scripting.filesystemobject")
vPath=request.servervariables("PATH_TRANSLATED")
set vThisFile=MyFileObject.GetFile(vPath)
key = left(vThisFile.Name,len(vThisFile.Name)-4)

'picPath="/blog_pro/images/"
picPath="/blog_pro/images/"

objConn.Open DSNConn

MyConn.open DSNConn

strSQL = "SELECT * from blog_pro WHERE author='" & id &"' and approved = 1 and removed IS NULL"
Set objRec=objConn.Execute(strSQL)
Set RS=MyConn.Execute(strSQL)

objcount=0

%>

<%
While Not objRec.EOF
objcount=objcount+1

%>

This last part is where my issues are coming from but I thought if I posted the beginning too then you could maybe tell me if I am missing something up there as well.

My images will not appear - they show the correct author name, but then it is NAME%20%20.jpg

How do I fix this?