Open Oracle Database in Excel
December 23, 2011 10:36 AM
I am using the following Excel subroutine to open and read an Oracle database table. It had worked fine for over a year until my PC crashed and I had to use a new PC. Now it works only the first time through and gives me the error message, "Error 440 - Unable to make connection, ORA-12154: TNS:could not resolve service name". The subroutine works fine on all the other PCs that I tested. The TNSnames.ORA file seems to be OK and is used by other applications.
Dim objSession As Object
Dim objDatabase As Object
I am using the following Excel subroutine to open and read an Oracle database table. It had worked fine for over a year until my PC crashed and I had to use a new PC. Now it works only the first time through and gives me the error message, "Error 440 - Unable to make connection, ORA-12154: TNS:could not resolve service name". The subroutine works fine on all the other PCs that I tested. The TNSnames.ORA file seems to be OK and is used by other applications.
Dim objSession As Object
Dim objDatabase As Object
0