• TNS Names not resolved means you have permission problem, you said Oracle 11g is installed locally then you need to go to BIDS and configure your connection to Oracle. I also think you need to put you TNSNAMES.ORA file in your development folder, so manually configure Oracle connection in BIDS and put your TNSNAMES.ORA file in your development folder.

    Kind regards,
    Gift Peddie