using 2 dsn in crystal reports

hello ,
i am using 2 oracle databse in a single crystal report . i created to dsn and report is working fine when checking from crystal report . but when i call the report from VB how we can pass two user details and dsn details to a single report using crystal.connect = "uid=production;pwd=admin;dsn=proddsn;uid=hr;pwd=hrpass;dsn=hrdsn"

but this using this line its connecting to only the last specified dsn . so please telll me how i can pass to dsn deatails from VB to crystal

thank you

thomas