You'll have to sue the LogonInfo method. The Connect method is only used if your report accesses only one database. If it tries for 2 or more you have to use LogonInfo. Specify the index as per the order of the tables in the report. e.g.
'crptDocList.LogonInfo(0) = "DSN = " & SQLName & ";UID = " & UID & ";PWD = " & PWD & ";DSQ = " & DBName
'crptDocList.LogonInfo(1) = "DSN = " & SQLName & ";UID = " & UID & ";PWD = " & PWD & ";DSQ = " & DBName