In your ADO Connection string, you should verify that it referneces the single server which HAS oracle on it.

http://www.able-consulting.com/ado_conn.htm

Get your connection string checked here.

Also make sure the computers are all networked properly.