We have an application that was written by one of our developers that is not able to work on it at the moment. It was written in VB6 and compiled on WinXP SP3. It works fine on our WinXP machines. We have recently upgraded many workstations to Win7-64 and the application is not connecting to Oracle and pops up an "Automation Error". That is all that is displayed and is a message created by the application for error handling, it's not very descriptive. I've been googling all day and all I really see is people saying they have problems running VB6 ADO applications compiled on Win7 to a lower Windows version. That is not our problem.

Is there something magical that needs to be done? Would simply installing VB6 on Win7 and recompiling there make it run? Would the connection string need changed? I don't know what it is, the developer is unavailable for a couple weeks and we're really hoping to get the application working before that. I have several VB6 apps that connect to access databases without trouble, but this one is connecting to Oracle. I've done a mock ODBC32 connection using the oracle driver and it works fine so I feel it has to be something in the app itself.

Thanks for any insight you may have